<!DOCTYPE html>
<!-- saved from url=(0104)https://support.office.com/zh-cn/article/vlookup-%E5%87%BD%E6%95%B0-0bbc8083-26fe-4963-8ab8-93a18ad188a1 -->
<html lang="zh-CN" dir="ltr" class="js"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><script async="" charset="UTF-8" src="./VLOOKUP 函数 - Office 支持_files/meCore.min.js.下载"></script><script async="" charset="UTF-8" src="./VLOOKUP 函数 - Office 支持_files/meBoot.min.js.下载"></script><style type="text/css">@charset "UTF-8";[ng\:cloak],[ng-cloak],[data-ng-cloak],[x-ng-cloak],.ng-cloak,.x-ng-cloak,.ng-hide{display:none !important;}ng\:form{display:block;}.ng-animate-block-transitions{transition:0s all!important;-webkit-transition:0s all!important;}.ng-hide-add-active,.ng-hide-remove{display:block!important;}</style>

	<title>VLOOKUP 函数 - Office 支持</title>
	
	<meta http-equiv="content-language" name="Language" content="zh-CN">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="format-detection" content="telephone=no">
	
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<link rel="shortcut icon" href="https://www.microsoft.com/favicon.ico?v2">
	<link rel="apple-touch-icon" href="https://www.microsoft.com/favicon.ico?v2">
	
	<meta name="twitter:card" value="Excel 中的 VLOOPUP 函数用于在表格或区域中按行查找内容。秘诀在于合理组织数据，确保查找的值位于希望找到的值的左侧。然后使用 VLOOKUP 找到该值。">
	<meta property="og:title" content="VLOOKUP 函数">

	<meta property="og:type" content="article">


	<meta property="og:image" content="//support.office.com/Images/SOC_SharingImage_720x405.png">

	<meta property="og:description" content="Excel 中的 VLOOPUP 函数用于在表格或区域中按行查找内容。秘诀在于合理组织数据，确保查找的值位于希望找到的值的左侧。然后使用 VLOOKUP 找到该值。">

	
			<link rel="canonical" href="https://support.office.com/zh-cn/article/vlookup-%e5%87%bd%e6%95%b0-0bbc8083-26fe-4963-8ab8-93a18ad188a1">
	<meta name="description" content="Excel 中的 VLOOPUP 函数用于在表格或区域中按行查找内容。秘诀在于合理组织数据，确保查找的值位于希望找到的值的左侧。然后使用 VLOOKUP 找到该值。">
	<meta name="SupportBridge">
	<meta name="ms.contentlang" content="zh-CHS">
	<meta name="C3_ENABLED" content="True">

			<meta name="intl.version" content="16">
			<meta name="intl.id" content="15954411">

		<meta name="keywords" content="VLOOKUP 函数, Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android 平板电脑版 Excel Starter 2010 Excel Mobile Excel for Android 手机版">

	

	<meta name="search.applicationSuite" content="Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel, Excel">
	<meta name="search.appverid" content="ZXL150, ZXL120, ZXL140, EXE140, WAE150, XCL150, MXL140, XCA150, XIP160, MXL160, EWT160, XLA160, ZXL160, ZXL190, MXL190, ZXL900, MXL900">
	<meta name="search.assetid" content="0bbc8083-26fe-4963-8ab8-93a18ad188a1">

	<meta name="search.audienceType" content="End User">
	<meta name="search.contenttype" content="Reference">
	<meta name="search.contextid" content="VLOOKUP, xlmain11.chm5209335, xlmain11.chm60150, XLWAEnduser_VLOOKUP">

	<meta name="search.IsOfficeDoc" content="content">

	<meta name="search.OCMSasset" content="HA102752820">
	<meta name="search.operatingSystemid" content="7478f241-7574-45ef-959c-b8be90099896">
	<meta name="search.operatingSystem" content="not applied">

	<meta name="search.sku" content="Excel, Excel Starter, Excel Online, Excel for iPad, Excel for Mac, Excel for Android tablets, Excel for iPhone, Excel for Mac, Excel Mobile, Excel for Android phones, Excel">
	<meta name="search.skuid" content="EXE140, WAE150, XCL150, MXL140, XCA150, XIP160, MXL160, EWT160, XLA160, ZXL160">
	<meta name="search.softwareVersion" content="15, 12, 14, 14, 15, 15, 14, 15, 16, 16, 16, 16, 16, 19, 19, 90, 90">
	<meta name="search.version" content="59">

<meta name="search.mkt" content="zh-CN">

	



<meta content="d36fb944-7b10-4888-8b3f-9ddf6579cad0" name="ms.correlationId">

<meta name="ms.lang" content="zh-CHS">
<meta name="ms.loc" content="CN">
<meta content="0bbc8083-26fe-4963-8ab8-93a18ad188a1" name="ms.ocpub.assetID">
<meta name="ms.pagetype" content="Article">
<meta name="ms.pltfrm" content="OCPub">
<meta name="ms.prod" content="Office">
<meta name="ms.sitesec" content="Support">
<meta name="ms.sitever" content="1601080737650">




	<meta name="contentlocation" content="https://osizpcusmagenta001.blob.core.windows.net">
	
<script type="text/javascript">
	var varSegmentation = 0;
	var varClickTracking = 0;
	var varCustomerTracking = 1;
	var varCustomerCookies = ["msresearch"];
	var varAutoFirePV = 0;
	var Route = '16000';
	var Ctrl = '010';
</script>
		<meta name="ms.pagescope" content="o365ww">
		<link href="./VLOOKUP 函数 - Office 支持_files/css" rel="stylesheet">

	<link href="./VLOOKUP 函数 - Office 支持_files/articleCss" rel="stylesheet">


<link href="./VLOOKUP 函数 - Office 支持_files/stickyFeedbackCss" rel="stylesheet">

	<link href="./VLOOKUP 函数 - Office 支持_files/officeShared" rel="stylesheet">

	
<link rel="stylesheet" href="./VLOOKUP 函数 - Office 支持_files/9c-2fd5c9" type="text/css" media="all"><link rel="stylesheet" href="./VLOOKUP 函数 - Office 支持_files/override.css" type="text/css">

<link href="./VLOOKUP 函数 - Office 支持_files/intl.css" rel="stylesheet">

	
<link href="./VLOOKUP 函数 - Office 支持_files/topNavCss" rel="stylesheet">

	<script type="text/javascript">
		var OOGlobal = {
			AutoSuggestEndPoint: "//dgps.support.microsoft.com/API/v1/AutoSuggestion",
			BaseDomain: location.protocol + "//" + location.host,
			Culture: "zh-CN",
			LCID: "2052",
			IsAuthenticated: "False",
			WebAppUrl: "https://office.com/start",
			GUID: "0bbc8083-26fe-4963-8ab8-93a18ad188a1",
			Platform: navigator.platform,
			MixOembedUrl: "https://mix.office.com/oembed/",
			MixWatchUrl: "https://mix.office.com/watch/",
			IsCookieConsentRequired: false
		};
		
	</script>
	

	<script type="text/javascript">
		var ariaToken = '1b3c419f862842df99f49c661508cc63-88b16260-a8e4-4d5d-8055-a5014e02c560-7464';
		var ariaTestTraffic = false;
	</script>

	<script src="./VLOOKUP 函数 - Office 支持_files/clientlogging"></script>


	<script type="text/javascript">
		if (typeof ClientSideLogging !== "undefined" && ClientSideLogging !== null) {
			(function(){
				var pageProperties = {
					cultureName: 'zh-CN',
					helpViewer: HelpViewers.web,
					machineId: 'ODCSUPFRONTEND_IN_9',
					region: 'CUS-000',
					build: '1601080737650'
				}

				ClientSideLogging.setPageProperties(pageProperties);
				ClientSideLogging.addListeners();
			})();
			

		}
	</script>

		<script type="text/javascript">
			if (typeof ClientSideLogging !== "undefined" && ClientSideLogging !== null) {
				ClientSideLogging.addPageProperty(PageProperties.pageType, 'Article');
			}
		</script>

	
			<script src="./VLOOKUP 函数 - Office 支持_files/8269159376.js.下载" id="supExperimentationScriptTag"></script>


<script src="./VLOOKUP 函数 - Office 支持_files/jsll-4.2.7.js.下载"></script>
<script>(window.awa)||document.write('<script src="/bundles/jsll"><\/script>');</script>




<meta name="awa-env" content="Production">
<meta name="awa-stv" content="1601080737650">
<meta name="awa-market" content="zh-CN">
<meta name="awa-asst" content="0bbc8083-26fe-4963-8ab8-93a18ad188a1">

<meta name="awa-pageType" content="Article">
<meta content="o365ww" name="awa-pagescope">
<meta content="office.com" name="awa-prdct">








<meta content="zh-CHS" name="awa-contentlang">
<script async="" src="./VLOOKUP 函数 - Office 支持_files/t.js.下载"></script><script async="" src="./VLOOKUP 函数 - Office 支持_files/t.js(1).下载"></script><script async="" src="./VLOOKUP 函数 - Office 支持_files/t.js(2).下载"></script><style type="text/css">.msame_TxtTrunc{white-space:nowrap;text-overflow:ellipsis;overflow:hidden;word-break:break-all}.msame_Header{display:inline-block;cursor:pointer;font-size:14px;border-width:1px;border-style:solid;border-bottom-style:none;border-color:transparent;width:100%}.msame_Header .msame_screen_reader{overflow:hidden;display:inline-block;width:1px;height:1px;position:absolute}.msame_Header_name{padding-left:12px;max-width:160px;display:inline-block;line-height:64px;vertical-align:top;font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;font-size:86%;color:#505050}.msame_unauth .msame_Header_name{padding-right:12px}.msame_unauth .msame_Header_name:hover{color:#0078d7}.msame_Drop_AI_pic,.msame_Drop_active_pic,.msame_Header_pic{display:inline-block}.msame_Header_piccont{padding-top:14px;padding-bottom:14px;padding-right:12px;padding-left:8px}.msame_Mobile .msame_Header_piccont{padding-top:10px;padding-bottom:10px}.msame_Short .msame_Header_piccont{padding-left:12px}.msame_Header_picframe{width:36px;height:36px;border-radius:50%;overflow:hidden}.msame_Mobile .msame_Header_picframe{width:48px;height:48px}.msame_open .msame_Header_picframe{z-index:3000001;position:relative}.msame_Header_chev{display:none}.msame_Mobile .msame_Header_piccont{padding-right:8px;padding-left:10px}.msame_Mobile .msame_Header_name{line-height:3;font-size:114%;padding-left:10px;padding-right:10px;display:inline-block;vertical-align:top;padding-top:14px}.msame_Mobile.msame_3row .msame_Header_name{padding-top:6px}.msame_Mobile .msame_Header_chev{display:inline-block;line-height:64px;vertical-align:top;padding-right:16px;padding-left:8px;float:right}.msame_open .msame_Header_chev img{-moz-transform:scaleY(-1);-o-transform:scaleY(-1);-webkit-transform:scaleY(-1);transform:scaleY(-1);filter:FlipV;-ms-filter:FlipV}.msame_Drop_root .msame_Drop_AI:focus,.msame_Drop_root .msame_Drop_AI_remove:focus,.msame_Drop_root a:focus,.msame_Header:focus{border-style:dashed;border-color:#000;border-width:1px}.msame_Header .msame_Header_piccont img{width:36px;height:36px;line-height:normal;vertical-align:baseline}.msame_Mobile .msame_Header_piccont img{width:48px;height:48px}.msame_Mobile .msame_Header_fullName{font-size:100%;color:#000;line-height:1.333}.msame_Drop_AI_email,.msame_Drop_AI_status,.msame_Mobile .msame_Header_email,.msame_Mobile .msame_Header_nickName{font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;font-size:86%;color:rgba(0,0,0,.54);line-height:1.333333}.msaie8 .msame_Drop_AI_pic,.msaie8 .msame_Drop_AI_right,.msaie8 .msame_Drop_active_pic,.msaie8 .msame_Drop_active_right,.msaie8 .msame_Header,.msaie8 .msame_Header_name,.msaie8 .msame_Header_pic{zoom:1}</style><style type="text/css">.msame_open .msame_Header{border-color:#e6e6e6;background-color:#fff}.msame_open .msame_Header.msame_Mobile{border-color:transparent;background-color:transparent}.msame_ClickStart.msame_Drop_root .msame_Drop_AI:focus,.msame_ClickStart.msame_Drop_root .msame_Drop_AI_remove:focus,.msame_ClickStart.msame_Drop_root a:focus{outline-style:none}.msame_Drop_root a,.msame_Drop_root a:active,.msame_Drop_root a:focus,.msame_Drop_root a:hover,.msame_Drop_root a:visited{text-decoration:none}.msame_Drop_topb{border-top-color:#e6e6e6;border-top-style:solid;border-top-width:1px}.msame_Mobile .msame_Drop_topb{width:100%!important}.msame_Drop_active{padding-bottom:8px}.msame_Drop_AI_picframe{width:44px;height:44px;border-radius:50%;overflow:hidden}.msame_Drop_AI_piccont img{width:44px;height:44px}.msame_Drop_root{border-width:1px;border-color:#e6e6e6;border-style:solid;border-top-style:none;position:absolute;width:360px;z-index:3000000;background-color:#fff;font-size:14px}.msame_Drop_sep{border-top-width:1px;border-top-color:#e6e6e6;border-top-style:solid;width:100%;height:0;display:block}.msame_Mobile.msame_Drop_root{left:0!important;right:0;bottom:0;width:100%;border-right-width:0;border-left-width:0}.msame_Mobile .msame_Drop_content{overflow-y:auto;position:absolute;left:0;right:0;bottom:0;top:0}.msame_Drop_root a{text-decoration:none}.msame_Drop_content{overflow:hidden}.msame_Mobile .msame_Drop_active{display:none}.msame_Drop_AI{cursor:pointer}.disabled .msame_Drop_AI_pic,.disabled .msame_Drop_AI_right{opacity:.4;cursor:default}.disabled .msame_Drop_AI_email,.disabled .msame_Drop_AI_name,.disabled .msame_Drop_AI_status{color:#000}.msame_Drop_active_piccont{padding:5px}.msame_Drop_AI_piccont{padding:10px}.msame_Drop_active_picframe{width:74px;height:74px;border-radius:50%;overflow:hidden}.msame_Drop_active_picborder,.msame_Drop_active_piccont a{display:block;padding:5px;border-radius:50%}.msame_Drop_active_piccont a:focus{padding:4px;border:1px dashed #000}.msame_Drop_active_piccont img{width:64px;height:64px;border-radius:50%}.msame_Drop_active_name{display:block;line-height:1.3;font-size:150%;color:#000;font-family:"Segoe UI Light","Segoe UI Web Light","Segoe UI Web Regular","Segoe UI","Segoe UI Symbol",HelveticaNeue-Light,"Helvetica Neue",Arial,sans-serif}.msame_Drop_active_email{display:block;line-height:1.42857;font-size:100%;color:rgba(0,0,0,.54);font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;padding:1px}.msame_Drop_active_right{display:inline-block;width:216px;vertical-align:top;padding-top:12px;padding-right:12px;padding-left:12px}.msame_Drop_active_right a{color:rgba(0,0,0,.54)}.msame_Drop_SI a{line-height:2;font-size:114%;font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;padding-left:12px;padding-right:12px;display:block;color:#000}.msame_Mobile .msame_Drop_SI a{line-height:2.75}.msame_Drop_AI.switch:hover,.msame_Drop_AI_remove:hover,.msame_Drop_SI a:hover{color:#000;background-color:rgba(0,0,0,.12)}.msame_Drop_AI.switch:active,.msame_Drop_AI.switch:active div,.msame_Drop_AI_remove:active,.msame_Drop_SI a:active{color:#fff!important;background-color:#000}.msame_Drop_SI a:link,.msame_Drop_SI a:visited{color:#000}.msame_Drop_active_link a,.msame_Drop_active_link a:active,.msame_Drop_active_link a:hover,.msame_Drop_active_link a:link,.msame_Drop_active_link a:visited{line-height:1.333333;font-size:86%;font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;color:#0078d7}.msame_Drop_AL{padding-bottom:24px}.msame_Drop_AI_right{display:inline-block;width:252px;vertical-align:top;padding-left:8px;padding-top:5px}.msame_Mobile .msame_Drop_AI_right{width:100px}.msame_Drop_AI_name{font-family:"Segoe UI","Segoe UI Web Regular","Segoe UI Symbol","Helvetica Neue","BBAlpha Sans","S60 Sans",Arial,sans-serif;font-size:114%;color:#000;line-height:1.25}.msame_Drop_AI_remove{float:right;margin-top:6px;padding-top:12px;padding-bottom:12px;padding-left:12px;padding-right:12px;text-align:center;cursor:pointer}.msame_Drop_AI_remove img{display:block}.msame_auto_frame{display:none;position:absolute;top:0;left:-4000px;width:0}</style><script async="" src="./VLOOKUP 函数 - Office 支持_files/t.js(3).下载"></script><script async="" src="./VLOOKUP 函数 - Office 支持_files/t.js(4).下载"></script><script async="" src="https://web.vortex.data.microsoft.com/collect/v1/t.js?ver=%272.1%27&amp;name=%27Ms.Webi.ContentUpdate%27&amp;time=%272018-08-10T04%3A35%3A26.620Z%27&amp;os=%27Windows%27&amp;appId=%27JS%3Asupport.office.com%27&amp;-ver=%271.0%27&amp;-impressionGuid=%27dc74c7e3-6465-4b0c-a17f-bf5f5e5ab26e%27&amp;-pageName=%27article%27&amp;-uri=%27https%3A%2F%2Fsupport.office.com%2Fzh-cn%2Farticle%2Fvlookup-%25E5%2587%25BD%25E6%2595%25B0-0bbc8083-26fe-4963-8ab8-93a18ad188a1%27&amp;-market=%27zh-CN%27&amp;-pageTags=%27%7B%22metaTags%22%3A%7B%22stv%22%3A%221601080737650%22%2C%22asst%22%3A%220bbc8083-26fe-4963-8ab8-93a18ad188a1%22%2C%22pagescope%22%3A%22o365ww%22%2C%22prdct%22%3A%22office.com%22%2C%22contentlang%22%3A%22zh-CHS%22%2C%22ms.contentlang%22%3A%22zh-CHS%22%2C%22ms.correlationId%22%3A%22d36fb944-7b10-4888-8b3f-9ddf6579cad0%22%2C%22ms.lang%22%3A%22zh-CHS%22%2C%22ms.loc%22%3A%22CN%22%2C%22ms.ocpub.assetID%22%3A%220bbc8083-26fe-4963-8ab8-93a18ad188a1%22%2C%22ms.pagetype%22%3A%22Article%22%2C%22ms.pltfrm%22%3A%22OCPub%22%2C%22ms.prod%22%3A%22Office%22%2C%22ms.sitesec%22%3A%22Support%22%2C%22ms.sitever%22%3A%221601080737650%22%2C%22ms.pagescope%22%3A%22o365ww%22%7D%7D%27&amp;-pageHeight=6167&amp;-vpHeight=741&amp;-vpWidth=1600&amp;-actionType=%27R%27&amp;-behavior=0&amp;-vScrollOffset=3400&amp;-hScrollOffset=0&amp;-contentVer=%272.0%27&amp;-content=%27%5B%7B%22contentId%22%3A%22supArticleContent%22%2C%22areaName%22%3A%22content%22%2C%22contentName%22%3A%22Excel%20%20%E5%85%AC%E5%BC%8F%E5%92%8C%E5%87%BD%E6%95%B0%20%20%E5%BC%95%E7%94%A8%20%20VLOOKUP%20%E5%87%BD%E6%95%B0%5CnVLOOKUP%20%E5%87%BD%E6%95%B0%5Cn%E9%80%82%E7%94%A8%E4%BA%8E%3A%20Excel%20for%20Office%20365%20Excel%20for%20Office%20365%20for%20Mac%20Excel%202016%20Excel%202013%20%E6%9B%B4%E5%A4%9A...%5Cn%E5%A6%82%E6%9E%9C%E9%9C%80%E8%A6%81%E5%9C%A8%E8%A1%A8%E6%A0%BC%E6%88%96%E5%8C%BA%E5%9F%9F%E4%B8%AD%E6%8C%89%E8%A1%8C%E6%9F%A5%E6%89%BE%E5%86%85%E5%AE%B9%EF%BC%8C%E5%8F%AF%E4%BD%BF%E7%94%A8%20VLOOKUP%EF%BC%8C%E5%AE%83%E6%98%AF%E4%B8%80%E4%B8%AA%E6%9F%A5%E6%89%BE%E5%92%8C%E5%BC%95%E7%94%A8%E5%87%BD%E6%95%B0%E3%80%82%E4%BE%8B%E5%A6%82%EF%BC%8C%E6%8C%89%E9%83%A8%E4%BB%B6%E5%8F%B7%E6%9F%A5%E6%89%BE%E6%B1%BD%E8%BD%A6%E9%83%A8%E4%BB%B6%E7%9A%84%E4%BB%B7%E6%A0%BC%E3%80%82%5Cn%5Cn%E5%9C%A8%E8%BF%99%E4%B8%80%E6%9C%80%E7%AE%80%E5%8D%95%E7%9A%84%E5%BD%A2%E5%BC%8F%E4%B8%AD%EF%BC%8CVLOOK%22%7D%5D%27&amp;*baseType=%27Ms.Content.ContentUpdate%27&amp;*title=%27VLOOKUP%20%E5%87%BD%E6%95%B0%20-%20Office%20%E6%94%AF%E6%8C%81%27&amp;*cookieEnabled=true&amp;*isJs=true&amp;*isDomComplete=false&amp;*isLoggedIn=false&amp;ext-app-env=%27Production%27&amp;ext-javascript-ver=%271.1%27&amp;ext-javascript-libVer=%274.2.7%27&amp;ext-javascript-domain=%27support.office.com%27&amp;ext-javascript-msfpc=%27GUID%3D57d560687ce14d6fbea19e85814e61bb%26HASH%3D57d5%26LV%3D201808%26V%3D4%26LU%3D1533808994307%27&amp;ext-javascript-userConsent=false&amp;$mscomCookies=false"></script></head>

<body class="supCont ocArticle ">
	<div id="ocBodyWrapper">
		
	

    <section id="headerArea" data-m="{&quot;cN&quot;:&quot;headerArea&quot;,&quot;cT&quot;:&quot;Area_coreuiArea&quot;,&quot;id&quot;:&quot;a1Body&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;Body&quot;}">
            <div id="headerRegion" data-region-key="headerregion" data-m="{&quot;cN&quot;:&quot;headerRegion&quot;,&quot;cT&quot;:&quot;Region_coreui-region&quot;,&quot;id&quot;:&quot;r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;a1&quot;}">

    <div id="headerUniversalHeader" data-m="{&quot;cN&quot;:&quot;headerUniversalHeader&quot;,&quot;cT&quot;:&quot;Module_coreui-universalheader&quot;,&quot;id&quot;:&quot;m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;r1a1&quot;}" data-module-id="Category|headerRegion|headerRegion|headerUniversalHeader|coreui-universalheader">
        



            <div id="epb" class="x-hidden x-hidden-vp1 x-hidden-vp2 uhfc-universal-context context-uhf" data-m="{&quot;cN&quot;:&quot;epb_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;m1r1a1&quot;}">



<div class="c-uhfh-alert f-information epb-container epb-default-color" role="banner" aria-label="banner" data-m="{&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1m1r1a1&quot;}">
    <div>        
        <p class="c-paragraph">
                <img alt="Microsoft Edge" data-src="https://img-prod-cms-rt-microsoft-com.akamaized.net/cms/api/am/imageFileData/REZlo1?ver=5722" src="https://support.office.com/zh-cn/article/vlookup-%E5%87%BD%E6%95%B0-0bbc8083-26fe-4963-8ab8-93a18ad188a1" class="f-img-lzy" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">

            <span class="c-text-group">
                <span class="epb-launch">试用- Microsoft Edge</span>
                <span class="epb-text">专为 Windows 10 设计的快速安全的浏览器</span>
            </span>
            <span class="c-group">
                <button id="close-epb" class="c-action-trigger c-action-cancel glyph-cancel" data-m="{&quot;cN&quot;:&quot;EPB-dismiss_nonnav&quot;,&quot;id&quot;:&quot;nn1c1c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c1m1r1a1&quot;}" aria-label="不，谢谢，我稍后再试用 Microsoft Edge。 ">不用了，谢谢</button>
                <a id="epbTryNow" data-telem-qsp="form=MY009W" aria-label="开始：在 Microsoft Edge 中打开此页面" class="epb-launch c-action-trigger c-action-open" data-m="{&quot;cN&quot;:&quot;EPB-launch_nav&quot;,&quot;id&quot;:&quot;n2c1c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c1m1r1a1&quot;}" ms.cmpgrp="content" ms.pgarea="Body">入门</a>
            </span>

        </p>
    </div>
</div>


                
            </div>





<header role="region" class="c-uhfh context-uhf" itemscope="itemscope" data-header-footprint="/officesupport/officesupportheader" data-ckrate="1" data-magict="true" itemtype="http://schema.org/Organization">
    <div class="theme-light js-global-head f-closed " data-m="{&quot;cN&quot;:&quot;Universal Header_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1m1r1a1&quot;}">
        <div class="c-uhfh-gcontainer">
            <button type="button" class="c-action-trigger c-glyph glyph-global-nav-button" aria-label="标题导航菜单" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;Mobile menu button_nonnav&quot;,&quot;id&quot;:&quot;nn1c2c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}"></button>
            <button type="button" class="c-action-trigger c-glyph glyph-arrow-htmllegacy" aria-label="关闭搜索" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;Close Search_nonnav&quot;,&quot;id&quot;:&quot;nn2c2c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}"></button>
                    <a id="uhfLogo" class="c-logo" itemprop="url" href="https://www.microsoft.com/" aria-label="Microsoft" data-m="{&quot;cN&quot;:&quot;GlobalNav_Logo_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c2c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}" data-bi-name="Microsoft" ms.cmpgrp="content" ms.pgarea="Body">
                        <img alt="Microsoft" itemprop="logo" itemscope="itemscope" class="c-image" src="./VLOOKUP 函数 - Office 支持_files/RE1Mu3b" role="presentation" ms.cmpgrp="content" ms.pgarea="Body">
                        <span role="presentation">Microsoft</span>
                    </a>
            <div class="f-mobile-title">
                <button type="button" class="c-action-trigger c-glyph glyph-chevron-left" aria-label="查看更多菜单选项" data-m="{&quot;cN&quot;:&quot;Mobile back button_nonnav&quot;,&quot;id&quot;:&quot;nn4c2c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}"></button>
                <span data-global-title="Microsoft 主页" class="js-mobile-title">Office</span>
                <button type="button" class="c-action-trigger c-glyph glyph-chevron-right" aria-label="查看更多菜单选项" data-m="{&quot;cN&quot;:&quot;Mobile forward button_nonnav&quot;,&quot;id&quot;:&quot;nn5c2c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}"></button>
            </div>

            
            <button type="button" class="c-action-trigger c-glyph glyph-chevron-left js-primary-paddle" data-m="{&quot;cN&quot;:&quot;Previous_nonnav&quot;,&quot;id&quot;:&quot;nn6c2c1m1r1a1&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}" aria-label="Show previous" tabindex="-1"></button>
            
            
            
            <button type="button" class="c-action-trigger c-glyph glyph-chevron-right js-secondary-paddle" data-m="{&quot;cN&quot;:&quot;Next_nonnav&quot;,&quot;id&quot;:&quot;nn7c2c1m1r1a1&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}" aria-label="Show next" tabindex="-1"></button>

                <div class="c-uhfh-actions" data-m="{&quot;cN&quot;:&quot;Header actions_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c8c2c1m1r1a1&quot;,&quot;sN&quot;:8,&quot;aN&quot;:&quot;c2c1m1r1a1&quot;}">
                                <form class="c-search ng-scope ng-pristine ng-valid" autocomplete="off" id="searchForm" name="searchForm" role="search" action="https://support.office.com/zh-cn/Search/results" method="GET" data-seautosuggest="{&quot;queryParams&quot;:{&quot;market&quot;:&quot;zh-cn&quot;,&quot;clientId&quot;:&quot;7F27B536-CF6B-4C65-8638-A0F8CBDFCA65&quot;,&quot;sources&quot;:&quot;Microsoft-Terms,Iris-Products,DCatAll-Products&quot;,&quot;filter&quot;:&quot;ExcludeDCatProducts:DCatDevices-Products,DCatSoftware-Products,DCatBundles-Products+ClientType:StoreWeb&quot;,&quot;counts&quot;:&quot;5,1,5&quot;},&quot;familyNames&quot;:{&quot;Apps&quot;:&quot;应用&quot;,&quot;Books&quot;:&quot;书籍&quot;,&quot;Bundles&quot;:&quot;套装&quot;,&quot;Devices&quot;:&quot;设备&quot;,&quot;Fees&quot;:&quot;Fee&quot;,&quot;Games&quot;:&quot;游戏&quot;,&quot;MusicAlbums&quot;:&quot;专辑&quot;,&quot;MusicTracks&quot;:&quot;歌曲&quot;,&quot;MusicVideos&quot;:&quot;视频&quot;,&quot;MusicArtists&quot;:&quot;艺术家&quot;,&quot;OperatingSystem&quot;:&quot;操作系统&quot;,&quot;Software&quot;:&quot;软件&quot;,&quot;Movies&quot;:&quot;影片&quot;,&quot;TV&quot;:&quot;电视&quot;,&quot;CSV&quot;:&quot;礼品卡&quot;,&quot;VideoActor&quot;:&quot;表演者&quot;}}" data-seautosuggestapi="https://www.microsoft.com/services/api/v3/suggest" data-m="{&quot;cN&quot;:&quot;GlobalNav_Search_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c8c2c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c8c2c1m1r1a1&quot;}" aria-expanded="false" ng-controller="autoSuggestController as main">
                <input id="cli_shellHeaderSearchInput" aria-label="搜索 Office 帮助" aria-autocomplete="both" aria-controls="universal-header-search-auto-suggest-transparent" aria-owns="universal-header-search-auto-suggest-ul" type="search" name="query" placeholder="搜索 Office 帮助" data-m="{&quot;cN&quot;:&quot;SearchBox_nav&quot;,&quot;id&quot;:&quot;n1c1c8c2c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c8c2c1m1r1a1&quot;}" ng-model="main.searchText" ng-change="main.fireAutoSuggest()" class="ng-pristine ng-valid" style="display: inline-block;"><div class="x-screen-reader" aria-live="assertive"></div>
                <button id="search" aria-label="搜索" class="c-glyph" data-m="{&quot;cN&quot;:&quot;Search_nav&quot;,&quot;id&quot;:&quot;n2c1c8c2c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c8c2c1m1r1a1&quot;}" data-bi-dnt="true" data-bi-mto="true"></button>
                <div class="m-auto-suggest" id="universal-header-search-auto-suggest-transparent" role="group">
                    <ul class="c-menu" id="universal-header-search-auto-suggest-ul" aria-hidden="true" data-bi-dnt="true" data-bi-mto="true" data-js-auto-suggest-position="default" role="listbox" data-tel="jsll" data-m="{&quot;cN&quot;:&quot;search suggestions_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c1c8c2c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1c8c2c1m1r1a1&quot;}"></ul>
                </div>
                
            <input type="text" id="supSuggestionHider" ng-init="main.tenant = &#39;web&#39;" ng-model="main.tenant" class="ng-pristine ng-valid"><auto-suggest search-input-box="#cli_shellHeaderSearchInput" search-submit="#search" search-input-type="button" suggestions="main.suggestions" search-text="main.searchText" show-suggestions="main.showSuggestions" selected-item="main.selectedItem" class="ng-isolate-scope"><span class="supAutoSuggestAccessibleText" role="status" aria-live="polite"></span><div class="supAutoSuggestContainer ng-hide" ng-show="showSuggestions"><ul class="supSuggestionList"><!-- ngRepeat: suggestion in suggestions --></ul></div></auto-suggest></form>

                                <a id="uhf-shopping-cart" aria-label="0 购物车中的物品" class="c-action-trigger c-glyph glyph-shopping-cart" href="https://www.microsoftstore.com.cn/cart" title="查看购物车" data-m="{&quot;cN&quot;:&quot;GlobalNav_Cart_nav&quot;,&quot;bhvr&quot;:82,&quot;id&quot;:&quot;n2c8c2c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c8c2c1m1r1a1&quot;}" ms.cmpgrp="content" ms.pgarea="Body">
                <span class="shopping-cart-amount x-hidden" aria-hidden="true">0</span>
            </a>
                <iframe id="shell-cart-count" title="购物车中的物品" data-src="//www.microsoftstore.com.cn/cart" style="display: none" src="./VLOOKUP 函数 - Office 支持_files/cart.html"></iframe>

                    
                                <div id="meControl" class="c-me" data-signinsettings="{&quot;containerId&quot;:&quot;meControl&quot;,&quot;enabled&quot;:true,&quot;headerHeight&quot;:48,&quot;debug&quot;:false,&quot;extensibleLinks&quot;:[],&quot;userData&quot;:{&quot;idp&quot;:&quot;msa&quot;,&quot;firstName&quot;:&quot;&quot;,&quot;lastName&quot;:&quot;&quot;,&quot;memberName&quot;:&quot;&quot;,&quot;cid&quot;:&quot;&quot;,&quot;authenticatedState&quot;:&quot;3&quot;},&quot;rpData&quot;:{&quot;preferredIdp&quot;:&quot;msa&quot;,&quot;msaInfo&quot;:{&quot;signInUrl&quot;:&quot;https://www.office.com/login?ru=%2f%3fauth%3d1\u0026es=click &quot;,&quot;signOutUrl&quot;:&quot;&quot;,&quot;meUrl&quot;:&quot;https://login.live.com/me.srf?wa=wsignin1.0&quot;},&quot;aadInfo&quot;:{&quot;signOutUrl&quot;:&quot;&quot;,&quot;appId&quot;:&quot;&quot;,&quot;siteUrl&quot;:&quot;&quot;,&quot;blockMsaFed&quot;:true}}}" data-m="{&quot;cN&quot;:&quot;GlobalNav_Account_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c8c2c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c8c2c1m1r1a1&quot;}"><div><div class="msame_header_focus_trap" tabindex="0" aria-hidden="true" style="display: none;"></div><div class="msame_Header msame_unauth" role="button" tabindex="0" aria-label="请登录你的帐户" title="请登录你的帐户" data-mc-m="{&quot;id&quot;:&quot;headerClick&quot;,&quot;aN&quot;:&quot;Me Control Header&quot;,&quot;cT&quot;:&quot;Button&quot;}" "="" style="height: 48px;"><span class="msame_screen_reader">请登录你的帐户</span><div aria-hidden="true" role="presentation"><div class="msame_Header_name msame_TxtTrunc" style="line-height: 48px;">登录</div><div class="msame_Header_chev"></div></div></div><div class="msame_header_focus_trap" tabindex="0" aria-hidden="true" style="display: none;"></div></div></div>

                    
                </div>
        </div>
        
        
    </div>
                <div class="theme-dark brand-neutral js-cat-head" itemprop="brand" itemscope="itemscope" itemtype="http://schema.org/Brand" data-m="{&quot;cN&quot;:&quot;UHF category nav_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1m1r1a1&quot;}" ms.pgarea="Header">

<div>
        <a id="uhfCatLogo" class="c-logo" href="https://www.office.com/" aria-label="Office" itemprop="url" data-m="{&quot;cN&quot;:&quot;Office_nav&quot;,&quot;id&quot;:&quot;n1c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" ms.pgarea="Body">
                <span>Office</span>
        </a>
    <a id="buyinstallbutton" class="c-call-to-action c-glyph" aria-label="购买 Office 365" data-m="{&quot;cN&quot;:&quot;购买 Office 365&quot;,&quot;cT&quot;:&quot;0&quot;,&quot;id&quot;:&quot;n2c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" href="https://go.microsoft.com/fwlink/?linkid=849747" ms.pgarea="Body">
                <span>购买 Office 365</span>
            </a>

    <button class="c-action-trigger c-glyph glyph-chevron-left js-primary-paddle" aria-label="向左滚动" title="向左滚动" data-m="{&quot;cN&quot;:&quot;Previous_nonnav&quot;,&quot;id&quot;:&quot;nn3c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" tabindex="-1" style="display: none;"></button>
    
    <button class="c-action-trigger c-glyph glyph-chevron-right js-secondary-paddle" aria-label="向右滚动" title="向右滚动" data-m="{&quot;cN&quot;:&quot;Next_nonnav&quot;,&quot;id&quot;:&quot;nn4c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" tabindex="-1" style="display: none;"></button>
            <nav id="uhf-c-nav" role="navigation" aria-label="office" class="js-paddle-items">

<div class="c-uhf-menu js-nav-menu" role="presentation" style="transition: margin 0.667s cubic-bezier(0.16, 1, 0.29, 0.99); margin-left: 0px;">
                        <button type="button" id="Products" aria-expanded="false" aria-haspopup="true" data-m="{&quot;cN&quot;:&quot;CatNav_Products_nonnav&quot;,&quot;id&quot;:&quot;nn5c3c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}">产品</button>
                        <ul class=" f-multi-column f-multi-column-4" aria-labelledby="Products" aria-hidden="true" data-m="{&quot;cN&quot;:&quot;Products_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c6c3c1m1r1a1&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}">
        <li class="f-sub-menu js-nav-menu" data-m="{&quot;cN&quot;:&quot;ForHome_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c6c3c1m1r1a1&quot;}">

            <button type="button" id="家用版&gt;-navigation" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;CatNav_ForHome_nonnav&quot;,&quot;id&quot;:&quot;nn1c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">家用版 &gt;</button>
            <ul aria-labelledby="家用版&gt;-navigation" aria-hidden="true">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;HomePlansPricing_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">
            <a id="HomePlansPricing" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/compare-all-microsoft-office-products?tab=1" data-m="{&quot;cN&quot;:&quot;CatNav_HomePlansPricing_nav&quot;,&quot;id&quot;:&quot;n1c2c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c1c6c3c1m1r1a1&quot;}" ms.pgarea="Body">计划与定价</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;for-households_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">
            <a id="for-households" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/office-365-home" data-m="{&quot;cN&quot;:&quot;CatNav_for-households_nav&quot;,&quot;id&quot;:&quot;n1c3c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c1c6c3c1m1r1a1&quot;}" ms.pgarea="Body">家用版</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;for-individuals_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">
            <a id="for-individuals" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/office-365-personal" data-m="{&quot;cN&quot;:&quot;CatNav_for-individuals_nav&quot;,&quot;id&quot;:&quot;n1c4c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c1c6c3c1m1r1a1&quot;}" ms.pgarea="Body">个人版</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;HomeSeeAllHome_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c5c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c1c6c3c1m1r1a1&quot;}">
            <a id="HomeSeeAllHome" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/explore-office-for-home" data-m="{&quot;cN&quot;:&quot;CatNav_HomeSeeAllHome_nav&quot;,&quot;id&quot;:&quot;n1c5c1c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c5c1c6c3c1m1r1a1&quot;}" ms.pgarea="Body">“查看全部”主页</a>
            
        </li>
            </ul>
            
        </li>
        <li class="f-sub-menu js-nav-menu" data-m="{&quot;cN&quot;:&quot;ForBusiness_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c6c3c1m1r1a1&quot;}">

            <button type="button" id="商业版&gt;-navigation" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;CatNav_ForBusiness_nonnav&quot;,&quot;id&quot;:&quot;nn1c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">商业版 &gt;</button>
            <ul aria-labelledby="商业版&gt;-navigation" aria-hidden="true">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;PlansPricing_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="PlansPricing" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/compare-all-microsoft-office-products?tab=2" data-m="{&quot;cN&quot;:&quot;CatNav_PlansPricing_nav&quot;,&quot;id&quot;:&quot;n1c2c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">计划与定价</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Smallbusiness_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="SmallBusiness" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/business/explore-office-365-for-business" data-m="{&quot;cN&quot;:&quot;CatNav_Smallbusiness_nav&quot;,&quot;id&quot;:&quot;n1c3c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">小型企业版</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Enterprise_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="Enterprise" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/business/enterprise-productivity-tools" data-m="{&quot;cN&quot;:&quot;CatNav_Enterprise_nav&quot;,&quot;id&quot;:&quot;n1c4c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">企业版</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;FrontlineWorkers_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c5c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="FrontlineWorkers" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/business/enterprise-firstline-workers" data-m="{&quot;cN&quot;:&quot;CatNav_FrontlineWorkers_nav&quot;,&quot;id&quot;:&quot;n1c5c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c5c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">一线员工</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;SeeAllBusiness_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c6c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c2c6c3c1m1r1a1&quot;}">
            <a id="SeeAllBusiness" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-CN/business/office" data-m="{&quot;cN&quot;:&quot;CatNav_SeeAllBusiness_nav&quot;,&quot;id&quot;:&quot;n1c6c2c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c6c2c6c3c1m1r1a1&quot;}" ms.pgarea="Body">查看所有商业版</a>
            
        </li>
            </ul>
            
        </li>
        <li class="f-sub-menu js-nav-menu" data-m="{&quot;cN&quot;:&quot;ForEducation_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c6c3c1m1r1a1&quot;}">

            <button type="button" id="教育版&gt;-navigation" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;CatNav_ForEducation_nonnav&quot;,&quot;id&quot;:&quot;nn1c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c6c3c1m1r1a1&quot;}">教育版 &gt;</button>
            <ul aria-labelledby="教育版&gt;-navigation" aria-hidden="true">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Studentsteachers_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c3c6c3c1m1r1a1&quot;}">
            <a id="Studentsteachers" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/home-and-student" data-m="{&quot;cN&quot;:&quot;CatNav_Studentsteachers_nav&quot;,&quot;id&quot;:&quot;n1c2c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c3c6c3c1m1r1a1&quot;}" ms.pgarea="Body">面向学生和教师</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Schools_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c3c6c3c1m1r1a1&quot;}">
            <a id="Schools" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/academic/office-365-education-plan" data-m="{&quot;cN&quot;:&quot;CatNav_Schools_nav&quot;,&quot;id&quot;:&quot;n1c3c3c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c3c6c3c1m1r1a1&quot;}" ms.pgarea="Body">面向学校</a>
            
        </li>
            </ul>
            
        </li>
        <li class="f-sub-menu js-nav-menu" data-m="{&quot;cN&quot;:&quot;applications_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c6c3c1m1r1a1&quot;}">

            <button type="button" id="应用程序&gt;-navigation" aria-expanded="false" data-m="{&quot;cN&quot;:&quot;CatNav_applications_nonnav&quot;,&quot;id&quot;:&quot;nn1c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">应用程序 &gt;</button>
            <ul aria-labelledby="应用程序&gt;-navigation" aria-hidden="true">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;outlook_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="outlook" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/outlook/email-and-calendar-software-microsoft-outlook" data-m="{&quot;cN&quot;:&quot;CatNav_outlook_nav&quot;,&quot;id&quot;:&quot;n1c2c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">Outlook</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;onedrive-for-business_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="onedrive-for-business" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/onedrive-for-business/online-cloud-storage" data-m="{&quot;cN&quot;:&quot;CatNav_onedrive-for-business_nav&quot;,&quot;id&quot;:&quot;n1c3c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">OneDrive</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;word_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="word" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/word" data-m="{&quot;cN&quot;:&quot;CatNav_word_nav&quot;,&quot;id&quot;:&quot;n1c4c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">Word</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;excel_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c5c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="excel" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/excel" data-m="{&quot;cN&quot;:&quot;CatNav_excel_nav&quot;,&quot;id&quot;:&quot;n1c5c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c5c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">Excel</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;powerpoint_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c6c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="powerpoint" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/powerpoint" data-m="{&quot;cN&quot;:&quot;CatNav_powerpoint_nav&quot;,&quot;id&quot;:&quot;n1c6c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c6c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">PowerPoint</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;onenote_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c7c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="onenote" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/onenote/digital-note-taking-app" data-m="{&quot;cN&quot;:&quot;CatNav_onenote_nav&quot;,&quot;id&quot;:&quot;n1c7c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c7c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">OneNote</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;sharepoint_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c8c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:8,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="sharepoint" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/sharepoint/collaboration" data-m="{&quot;cN&quot;:&quot;CatNav_sharepoint_nav&quot;,&quot;id&quot;:&quot;n1c8c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c8c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">SharePoint</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;microsoft-teams_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c9c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:9,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="microsoft-teams" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/microsoft-teams/group-chat-software" data-m="{&quot;cN&quot;:&quot;CatNav_microsoft-teams_nav&quot;,&quot;id&quot;:&quot;n1c9c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c9c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">Microsoft Teams</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;see-all-office-products_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c10c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:10,&quot;aN&quot;:&quot;c4c6c3c1m1r1a1&quot;}">
            <a id="see-all-office-products" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-cn/products" data-m="{&quot;cN&quot;:&quot;CatNav_see-all-office-products_nav&quot;,&quot;id&quot;:&quot;n1c10c4c6c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c10c4c6c3c1m1r1a1&quot;}" ms.pgarea="Body">查看所有 Office 产品</a>
            
        </li>
            </ul>
            
        </li>
                            
                        </ul>
                    </div><div class="c-uhf-menu js-nav-menu" role="presentation">
                        <button type="button" id="resources" aria-expanded="false" aria-haspopup="true" data-m="{&quot;cN&quot;:&quot;CatNav_Resources_nonnav&quot;,&quot;id&quot;:&quot;nn7c3c1m1r1a1&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}">资讯</button>
                        <ul class="" aria-labelledby="resources" aria-hidden="true" data-m="{&quot;cN&quot;:&quot;Resources_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c8c3c1m1r1a1&quot;,&quot;sN&quot;:8,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}">
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;Training_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c8c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c8c3c1m1r1a1&quot;}">
            <a id="Training" class="js-subm-uhf-nav-link" href="https://support.office.com/zh-cn/office-training-center?ms.officeurl=training" data-m="{&quot;cN&quot;:&quot;CatNav_Training_nav&quot;,&quot;id&quot;:&quot;n1c1c8c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c8c3c1m1r1a1&quot;}" ms.pgarea="Body">培训</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;SetupAndInstall_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c8c3c1m1r1a1&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c8c3c1m1r1a1&quot;}">
            <a id="SetupAndInstall" class="js-subm-uhf-nav-link" href="https://support.office.com/zh-cn/article/download-and-install-or-reinstall-office-365-or-office-2016-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658" data-m="{&quot;cN&quot;:&quot;CatNav_SetupAndInstall_nav&quot;,&quot;id&quot;:&quot;n1c2c8c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c8c3c1m1r1a1&quot;}" ms.pgarea="Body">安装程序和安装</a>
            
        </li>
        <li class="js-nav-menu" data-m="{&quot;cN&quot;:&quot;FAQ_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c8c3c1m1r1a1&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c8c3c1m1r1a1&quot;}">
            <a id="FAQ" class="js-subm-uhf-nav-link" href="https://products.office.com/zh-CN/microsoft-office-for-home-and-school-faq" data-m="{&quot;cN&quot;:&quot;CatNav_FAQ_nav&quot;,&quot;id&quot;:&quot;n1c3c8c3c1m1r1a1&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c8c3c1m1r1a1&quot;}" ms.pgarea="Body">常见问题</a>
            
        </li>
                            
                        </ul>
                    </div>                        <a id="c-shellmenu_29" class="c-uhf-nav-link" href="https://templates.office.com/" data-m="{&quot;cN&quot;:&quot;CatNav_Templates_nav&quot;,&quot;id&quot;:&quot;n9c3c1m1r1a1&quot;,&quot;sN&quot;:9,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" ms.pgarea="Body">模板</a>
                        <a id="shell-main-tab" class="c-uhf-nav-link f-current" href="https://support.office.com/" data-m="{&quot;cN&quot;:&quot;CatNav_Support_nav&quot;,&quot;id&quot;:&quot;n10c3c1m1r1a1&quot;,&quot;sN&quot;:10,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" ms.pgarea="Body">支持</a>
            <a id="mobile-buyInstallButton" class="c-uhf-nav-link x-hidden x-visible-vp2-block x-visible-vp1-block" href="https://go.microsoft.com/fwlink/?linkid=849747" data-m="{&quot;cN&quot;:&quot;CatNav_购买 Office 365_nav&quot;,&quot;id&quot;:&quot;n11c3c1m1r1a1&quot;,&quot;sN&quot;:11,&quot;aN&quot;:&quot;c3c1m1r1a1&quot;}" ms.pgarea="Body">购买 Office 365</a>
        </nav>

</div>


                
            </div>

    
</header>


    </div>
    </div>

    </section>



		





	<div id="topNav" class="topNav " ms.pgarea="topnav" data-bi-area="topnav">
		<div id="topNavMobileDropdown">
			<div class="topNavMobileCategory" id="topNavMobileDropdownButton">
				<a class="topNavDropdownTrigger" href="javascript:" aria-expanded="false" aria-label="支持" ms.cmpgrp="content" ms.pgarea="Body" data-bi-bhvr="EXPAND">
					<span>支持</span>
					<span class="topNavChevron ms-Icon--chevronThinDown"></span>
				</a>
			</div>
		</div>
		<ul id="topNavCategories">
						<li class="topNavCategory" ms.cmpgrp="apps">
							<a class="topNavDropdownTrigger" href="javascript:" ms.interactiontype="11" aria-expanded="False" aria-label="应用" data-bi-name="应用" data-bi-slot="100" data-bi-bhvr="EXPAND" ms.cmpgrp="content" ms.pgarea="Body">
								<span>应用</span>
								<span class="topNavChevron ms-Icon--chevronThinDown"></span>
							</a>
							<ul class="topNavDropdownMenu">
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/outlook" class="topNavDropdownLink" data-bi-name="Outlook" data-bi-slot="101" ms.cmpgrp="content" ms.pgarea="Body">Outlook</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/onedrive" class="topNavDropdownLink" data-bi-name="OneDrive" data-bi-slot="102" ms.cmpgrp="content" ms.pgarea="Body">OneDrive</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/word" class="topNavDropdownLink" data-bi-name="Word" data-bi-slot="103" ms.cmpgrp="content" ms.pgarea="Body">Word</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/excel" class="topNavDropdownLink" data-bi-name="Excel" data-bi-slot="104" ms.cmpgrp="content" ms.pgarea="Body">Excel</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/powerpoint" class="topNavDropdownLink" data-bi-name="PowerPoint" data-bi-slot="105" ms.cmpgrp="content" ms.pgarea="Body">PowerPoint</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/onenote" class="topNavDropdownLink" data-bi-name="OneNote" data-bi-slot="106" ms.cmpgrp="content" ms.pgarea="Body">OneNote</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/sharepoint" class="topNavDropdownLink" data-bi-name="SharePoint" data-bi-slot="107" ms.cmpgrp="content" ms.pgarea="Body">SharePoint</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/teams" class="topNavDropdownLink" data-bi-name="Microsoft Teams" data-bi-slot="108" ms.cmpgrp="content" ms.pgarea="Body">Microsoft Teams</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/yammer" class="topNavDropdownLink" data-bi-name="Yammer" data-bi-slot="109" ms.cmpgrp="content" ms.pgarea="Body">Yammer</a></li>
										<li class="topNavDropdownMenuItem"><a href="https://support.office.com/zh-cn/access" class="topNavDropdownLink" data-bi-name="Access" data-bi-slot="110" ms.cmpgrp="content" ms.pgarea="Body">Access</a></li>

							</ul>
						</li>
						<li class="topNavTopLevelMenuItem topNavDropdownMenuItem">
							<a href="https://support.office.com/zh-cn/article/4414eaaf-0478-48be-9c42-23adc4716658" class="topNavDropdownLink" data-bi-name="安装" data-bi-slot="200" ms.cmpgrp="content" ms.pgarea="Body">安装</a>
						</li>
						<li class="topNavTopLevelMenuItem topNavDropdownMenuItem">
							<a href="https://support.office.com/zh-cn/article/b9582171-fd1f-4284-9846-bdd72bb28426" class="topNavDropdownLink" data-bi-name="帐户" data-bi-slot="300" ms.cmpgrp="content" ms.pgarea="Body">帐户</a>
						</li>
						<li class="topNavTopLevelMenuItem topNavDropdownMenuItem">
							<a href="https://support.office.com/zh-cn/office-training-center" class="topNavDropdownLink" data-bi-name="培训" data-bi-slot="400" ms.cmpgrp="content" ms.pgarea="Body">培训</a>
						</li>
						<li class="topNavTopLevelMenuItem topNavDropdownMenuItem">
							<a href="https://support.office.com/zh-cn/office365admin" class="topNavDropdownLink" data-bi-name="管理员" data-bi-slot="500" ms.cmpgrp="content" ms.pgarea="Body">管理员</a>
						</li>

		</ul>
	</div>

		

		



		<section id="ocHelp" dir="ltr">
			<div id="ocArticle">
				

				<div class="grd main-content zero-margin" id="ocMainContent" role="main">
					<div class="row ocpArticleSizingWrapper">
						

						<div id="supArticleContent" class="col-5-5" data-bi-area="content">
							



	<div class="supBreadcrumbContainer" ms.pgarea="breadcrumbs" data-bi-area="breadcrumbs">
		<div class="supBreadcrumb">
			<a class="supBreadcrumbLink" href="https://support.office.com/zh-cn/excel" ms.cmpgrp="collection" data-bi-slot="1" ms.pgarea="Body">Excel</a>
		</div>
			<div class="supBreadcrumbPartition">
			</div>
			<div class="supBreadcrumb">
				<a class="supBreadcrumbLink" href="https://support.office.com/zh-cn/article/Formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9" ms.cmpgrp="primary" data-bi-slot="2" ms.pgarea="Body">公式和函数</a>
			</div>
				<div class="supBreadcrumbPartition">
				</div>
				<div class="supBreadcrumb">
					<a class="supBreadcrumbLink" href="https://support.office.com/zh-cn/article/Formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9#ID0EAABAAA=Reference" ms.cmpgrp="secondary" data-bi-slot="3" ms.pgarea="Body">引用</a>
				</div>
				<div class="supBreadcrumbMobile">
					<a class="supBreadcrumbLink" href="https://support.office.com/zh-cn/article/Formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9#ID0EAABAAA=Reference" ms.cmpgrp="content" ms.pgarea="Body">
						<span class="supBreadcrumbMobileChevron"></span>
						引用
					</a>
				</div>

		<div class="supBreadcrumbPartition">
		</div>
		<div class="supBreadcrumb">
			<div class="supBreadcrumbArticleTitle">VLOOKUP 函数</div>
		</div>
	</div>

							<!--If multimedia nav, hide the title and Applies To:-->
								<section class="ocpArticleTitleSection">
									<h1>VLOOKUP 函数</h1>
								</section>

							
				<section class="supAppliesToSection" ms.cmpgrp="applies_to" aria-label="本文" dir="ltr">
					<div id="supAppliesToTableContainer">
						<div id="supAppliesToList" class="appliesTo collapsed">
							<span>适用于: </span>
								<span class="appliesToItem">Excel for Office 365</span>
								<span class="appliesToItem">Excel for Office 365 for Mac</span>
								<span class="appliesToItem">Excel 2016</span>
								<span class="appliesToItem">Excel 2013</span>
								<span class="appliesToItem ocHidden">Excel 2010</span>
								<span class="appliesToItem ocHidden">Excel 2007</span>
								<span class="appliesToItem ocHidden">Excel 2016 for Mac</span>
								<span class="appliesToItem ocHidden">Excel for Mac 2011</span>
								<span class="appliesToItem ocHidden">Excel Online</span>
								<span class="appliesToItem ocHidden">Excel for iPad</span>
								<span class="appliesToItem ocHidden">Excel for iPhone</span>
								<span class="appliesToItem ocHidden">Excel for Android 平板电脑版</span>
								<span class="appliesToItem ocHidden">Excel 2019 for Mac</span>
								<span class="appliesToItem ocHidden">Excel for Android 手机版</span>
								<span class="appliesToItem ocHidden">Excel Mobile</span>
								<span class="appliesToItem ocHidden">Excel Starter 2010</span>
							<a tabindex="0" class="appliesToOverflowControl expand font-bold" href="javascript:" ms.interactiontype="11" ms.title="Less applies to" aria-label="按 Enter 键可了解本帮助文章适用的其他 Office 版本。" ms.cmpgrp="content" ms.pgarea="Body" data-bi-bhvr="EXPAND" data-bi-area="applies_to">更多...</a>
							<a tabindex="0" class="appliesToOverflowControl collapse ocHidden font-bold" href="javascript:" ms.interactiontype="11" ms.title="More applies to" ms.cmpgrp="content" ms.pgarea="Body" data-bi-bhvr="REDUCE" data-bi-area="applies_to">更少</a>
						</div>
					</div>
				</section>

							



<article id="ocpArticleContent" class="ocpArticleContent">
  <a name="__top" aria-hidden="true" xmlns:antixss="urn:AntiXSSExtensions" ms.cmpgrp="content" ms.pgarea="Body">	</a>
  <section class="ocpIntroduction">
    <a name="__goback" aria-hidden="true" xmlns:antixss="urn:AntiXSSExtensions" ms.cmpgrp="content" ms.pgarea="Body">	</a>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">如果需要在表格或区域中按行查找内容，可使用 VLOOKUP，它是一个<a href="https://support.office.com/zh-cn/article/&amp;#26597;&amp;#25214;&amp;#21644;&amp;#24341;&amp;#29992;&amp;#20989;&amp;#25968;&amp;#65288;&amp;#21442;&amp;#32771;&amp;#65289;-8aa21a3a-b56a-4055-8257-3ec89df2b23e" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">查找和引用函数</a>。例如，按部件号查找汽车部件的价格。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">在这一最简单的形式中，VLOOKUP 函数表示：</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">=VLOOKUP（要查找的值、要在其中查找值的区域、区域中包含返回值的列号、精确匹配或近似匹配 – 指定为 0/FALSE 或 1/TRUE）。</p>
    <div class="ocpVideo" data-channel="ALTENUS_MS_OFFICE" data-videoid="RWfvSj" data-llcc="zh-cn" data-videotype="single" data-player="SP_MOD_OfficeCom" xmlns:antixss="urn:AntiXSSExtensions" id="ocpVideo0"><div id="ocpVideo0-subdiv" style="width: 100%; position: relative; padding-top: 28.125%; padding-bottom: 28.125%;"><div id="ocpVideo0-innerdiv" style="top: 0px; bottom: 0px; position: absolute; height: 100%; width: 100%;"><iframe id="ocpVideo0-innerdiv-oneplayer" src="./VLOOKUP 函数 - Office 支持_files/RWfvSj.html" class="oneplayer-iframe" allowfullscreen="true" frameborder="0" name="Oneplayer iframe" style="height: 100%; width: 100%;"></iframe></div></div></div>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">此视频是名为 <a href="https://support.office.com/zh-cn/article/vlookup&amp;#65306;&amp;#20309;&amp;#26102;&amp;#20197;&amp;#21450;&amp;#22914;&amp;#20309;&amp;#20351;&amp;#29992;&amp;#23427;-9a86157a-5542-4148-a536-724823014785" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">VLOOKUP：何时以及如何使用它</a>的培训课程的一部分。</p>
    <div class="ocpAlert" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <p class="ocpAlertSection">
        <b class="ocpNote">提示:</b>&nbsp;VLOOKUP 的秘诀在于组织数据，这样您查找的值（部件号）位于要查找的返回值（部件价格）的左侧。</p>
    </div>
  </section>
  
  <section class="ocpSection">
    <h2 class="ocpExpandoHead">
      <a href="javascript:" ms.interactiontype="11" aria-expanded="false" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup" data-bi-slot="1" data-bi-mto="" ms.cmpgrp="content" ms.pgarea="Body">
        <div class="ocpExpandoHeadChevronContainer">
          <i class="ms-Icon--chevronThinDown ocpExpander"></i>
        </div>
        <div class="ocpExpandoHeadTitleContainer">技术细节</div>
      </a>
    </h2>
    <div class="ocpebw" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <div class="ocpExpandoBody">
        <p>使用 VLOOKUP 函数在表中查找值。</p>
        <p>
          <b class="ocpLegacyBold">语法</b>
        </p>
        <p>
          <b class="ocpLegacyBold">VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])</b>
        </p>
        <p>例如：</p>
        <ul>
          <li>
            <p>=VLOOKUP(105,A2:C7,2,TRUE)</p>
          </li>
          <li>
            <p>=VLOOKUP("袁",B2:E7,2,FALSE)</p>
          </li>
        </ul>
        <table id="tblID0EAAIAAA" class="banded flipColors">
          <thead>
            <tr>
              <td>
                <p>
                  <b class="ocpLegacyBold">参数名称</b>
                </p>
              </td>
              <td>
                <p>
                  <b class="ocpLegacyBold">说明</b>
                </p>
              </td>
            </tr>
          </thead>
          <tbody>
            <tr>
              <td>
                <p>
                  <b class="ocpRunInHead">lookup_value</b>&nbsp;&nbsp;&nbsp;（必需参数）</p>
              </td>
              <td>
                <p>要查找的值。要查找的值必须位于 <b class="ocpLegacyBold"><i class="ocpItalic">table-array</i></b> 中指定的单元格区域的第一列中。</p>
                <p>例如，如果 <b class="ocpLegacyBold"><i class="ocpItalic">table-array</i></b> 指定的单元格为 B2:D7，则 lookup_value 必须位于列 B 中。请参见下图。<b class="ocpLegacyBold"><i class="ocpItalic">Lookup_value</i></b> 可以是值，也可以是单元格引用。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>
                  <b class="ocpRunInHead">Table_array</b>&nbsp;&nbsp;&nbsp;（必需参数）</p>
              </td>
              <td>
                <p>VLOOKUP 在其中搜索 <b class="ocpLegacyBold"><i class="ocpItalic">lookup_value</i></b> 和返回值的单元格区域。</p>
                <p>该单元格区域中的第一列必须包含 <b class="ocpLegacyBold"><i class="ocpItalic">lookup_value</i></b>（例如，下图中的“姓氏”）。此单元格区域中还需要包含您要查找的返回值（例如，下图中的“名字”）。</p>
                <p>了解如何<a href="https://support.office.com/zh-cn/article/&amp;#22312;&amp;#24037;&amp;#20316;&amp;#34920;&amp;#20013;&amp;#36873;&amp;#25321;&amp;#21333;&amp;#20803;&amp;#26684;&amp;#12289;&amp;#21306;&amp;#22495;&amp;#12289;&amp;#34892;&amp;#25110;&amp;#21015;-23f64223-2b6b-453a-8688-248355f10fa9" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">选择工作表中的区域</a>。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>
                  <b class="ocpRunInHead">col_index_num</b>&nbsp;&nbsp;&nbsp;（必需参数）</p>
              </td>
              <td>
                <p>其中包含返回值的单元格的编号（<b class="ocpLegacyBold"><i class="ocpItalic">table-array</i></b> 最左侧单元格为 1 开始编号）。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>
                  <b class="ocpRunInHead">range_lookup</b>&nbsp;&nbsp;&nbsp;（可选参数）</p>
              </td>
              <td>
                <p>一个逻辑值，该值指定希望 <b class="ocpLegacyBold">VLOOKUP</b> 查找近似匹配还是精确匹配：</p>
                <ul>
                  <li>
                    <p>
                      <b class="ocpUI">TRUE</b> 假定表中的第一列按数字或字母排序，然后搜索最接近的值。这是未指定值时的默认方法。</p>
                  </li>
                  <li>
                    <p>
                      <b class="ocpUI">FALSE</b> 在第一列中搜索精确值。</p>
                  </li>
                </ul>
              </td>
            </tr>
          </tbody>
        </table>
      </div>
    </div>
  </section>
  <section class="ocpSection">
    <h2>如何开始</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">您需要四条信息才能构建 VLOOKUP 语法：</p>
    <ol type="1" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <li>
        <p>要查找的值，也被称为查阅值。</p>
      </li>
      <li>
        <p>查阅值所在的区域。请记住，查阅值应该始终位于所在区域的第一列，这样 VLOOKUP 才能正常工作。例如，如果查阅值位于单元格 C2 内，那么您的区域应该以 C 开头。</p>
      </li>
      <li>
        <p>区域中包含返回值的列号。例如，如果指定 B2：D11 作为区域，那么应该将 B 算作第一列，C 作为第二列，以此类推。</p>
      </li>
      <li>
        <p>（可选）如果需要返回值的近似匹配，可以指定 TRUE；如果需要返回值的精确匹配，则指定 FALSE。如果没有指定任何内容，默认值将始终为 TRUE 或近似匹配。</p>
      </li>
    </ol>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">现在将上述所有内容集中在一起，如下所示：</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup" class="">=VLOOKUP（查阅值、包含查阅值的区域、区域中包含返回值的列号以及（可选）为近似匹配指定 TRUE 或者为精确匹配指定 FALSE）。</p>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">下图显示了如何设置 VLOOKUP 以返回<i class="ocpItalic">刹车盘</i>的价格，即 <b class="ocpLegacyBold">85.73</b>。</p>
    <img src="./VLOOKUP 函数 - Office 支持_files/dac5293a-8860-4b06-867a-83a95332d9e5.png" alt="VLOOKUP 示例" xmlns:antixss="urn:AntiXSSExtensions" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500" class="">
    <ol type="1" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <li>
        <p>D13 是lookup_value，即要查找的值。</p>
      </li>
      <li>
        <p>B2 到 E11（在表中以黄色突出显示）是 table_array，即查阅值所在的区域。</p>
      </li>
      <li>
        <p class="">3 是 col_index_num，即 table_array 中包含返回值的列号。在此示例中，表数组中的第三列是“<b class="ocpLegacyBold">零件价格</b>”，因此公式输出将是“<b class="ocpLegacyBold">零件价格</b>”列中的值。</p>
      </li>
      <li>
        <p>FALSE 是 range_lookup，因此返回值将是精确匹配项。</p>
      </li>
      <li>
        <p>VLOOKUP 公式的输出是<b class="ocpLegacyBold">刹车盘</b>的价格，即 <i class="ocpItalic">85.73</i>。</p>
      </li>
    </ol>
  </section>
  <section class="ocpSection">
    <h2>示例</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">下面是有关 VLOOKUP 的几个例子：</p>
    <section class="ocpSection">
      <h3>示例 1</h3>
      <img src="./VLOOKUP 函数 - Office 支持_files/0d08ad32-9e64-4578-89af-4c85683394b6.png" alt="VLOOKUP 示例 1" xmlns:antixss="urn:AntiXSSExtensions" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500" class="">
    </section>
    <section class="ocpSection">
      <h3>示例 2</h3>
      <img src="./VLOOKUP 函数 - Office 支持_files/ddaf561c-1df2-4f13-a136-a79e65a3ee6f.png" alt="VLOOKUP 示例 2" xmlns:antixss="urn:AntiXSSExtensions" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">
    </section>
    <section class="ocpSection">
      <h3>示例 3</h3>
      <img src="./VLOOKUP 函数 - Office 支持_files/28e39ac1-7552-4258-90d5-b38b37deb2b1.png" alt="VLOOKUP 示例 3" xmlns:antixss="urn:AntiXSSExtensions" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">
    </section>
    <section class="ocpSection">
      <h3>示例 4</h3>
      <img src="./VLOOKUP 函数 - Office 支持_files/d9011e9d-e702-4fac-8434-1112907e96e3.png" alt="VLOOKUP 示例 4" xmlns:antixss="urn:AntiXSSExtensions" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">
    </section>
    <section class="ocpSection">
      <h3>示例 5</h3>
      <img src="./VLOOKUP 函数 - Office 支持_files/dcfda044-79a4-40e1-a2c2-878a90ab8ecb.png" alt="VLOOKUP 示例 5" xmlns:antixss="urn:AntiXSSExtensions" ms.cmpgrp="content" ms.pgarea="Body" ms.interactiontype="500">
    </section>
  </section>
  <section class="ocpSection">
    <h2 class="ocpExpandoHead">
      <a href="javascript:" ms.interactiontype="11" aria-expanded="false" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup" data-bi-slot="2" data-bi-mto="" ms.cmpgrp="content" ms.pgarea="Body">
        <div class="ocpExpandoHeadChevronContainer">
          <i class="ms-Icon--chevronThinDown ocpExpander"></i>
        </div>
        <div class="ocpExpandoHeadTitleContainer">常见问题</div>
      </a>
    </h2>
    <div class="ocpebw" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <div class="ocpExpandoBody">
        <table id="tblID0EAAFAAA" class="banded flipColors">
          <thead>
            <tr>
              <td>
                <p>
                  <b class="ocpLegacyBold">问题</b>
                </p>
              </td>
              <td>
                <p>
                  <b class="ocpLegacyBold"> 出错原因</b>
                </p>
              </td>
            </tr>
          </thead>
          <tbody>
            <tr>
              <td>
                <p>返回了错误值</p>
              </td>
              <td>
                <p>如果 <b class="ocpLegacyBold"><i class="ocpItalic">range_lookup</i></b> 为 TRUE 或被排除在外，需要对第一列按字母或数字顺序排序。如果未对第一列排序，可能会返回意外值。请对第一列排序，或使用 FALSE 以获得精确匹配项。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>单元格中显示 #N/A</p>
              </td>
              <td>
                <ul>
                  <li>
                    <p>如果 <b class="ocpLegacyBold"><i class="ocpItalic">range_lookup</i></b> 为 TRUE，并且 <b class="ocpLegacyBold"><i class="ocpItalic">lookup_value</i></b> 中的值比 <b class="ocpLegacyBold"><i class="ocpItalic">table_array</i></b> 的第一列中的最小值小，将显示错误值 #N/A。</p>
                  </li>
                  <li>
                    <p>如果 <b class="ocpLegacyBold"><i class="ocpItalic">range_lookup</i></b> 为 FALSE，则错误值 #N/A 表示未找到精确匹配项。</p>
                  </li>
                </ul>
                <p>有关在 VLOOKUP 中解决 #N/A 错误的详细信息，请参阅<a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#26356;&amp;#27491;-vlookup-&amp;#20989;&amp;#25968;&amp;#20013;&amp;#30340;-n-a-&amp;#38169;&amp;#35823;-e037d763-ffc3-4fae-a909-89c482d389b2" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">如何在 VLOOKUP 函数中更正 #N/A 错误</a>。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>单元格中显示 #REF!</p>
              </td>
              <td>
                <p>如果 <b class="ocpLegacyBold"><i class="ocpItalic">col_index_num</i></b> 大于 <b class="ocpLegacyBold"><i class="ocpItalic">table-array</i></b> 中的列数，则显示错误值 #REF!。</p>
                <p>有关在 VLOOKUP 中解决 #REF! 错误的详细信息，请参阅<a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#26356;&amp;#27491;-ref-&amp;#38169;&amp;#35823;-822c8e46-e610-4d02-bf29-ec4b8c5ff4be" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">如何更正 #REF! 错误</a>。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>单元格中显示 #VALUE!</p>
              </td>
              <td>
                <p>如果 <b class="ocpLegacyBold"><i class="ocpItalic">table_array</i></b> 小于 1，则显示错误值 #VALUE!。</p>
                <p>有关在 VLOOKUP 中解决 #VALUE! 错误的详细信息，请参阅 <a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#26356;&amp;#27491;-vlookup-&amp;#20989;&amp;#25968;&amp;#30340;-value-&amp;#38169;&amp;#35823;-1fabc766-32ae-4f7f-a2c4-d095153e6894" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">如何在 VLOOKUP 函数中更正 #VALUE! 错误</a>。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>单元格中的 #NAME?</p>
              </td>
              <td>
                <p>错误值 #NAME? 通常意味着该公式缺少引号。 要查找人员的姓名，请确保在公式中的姓名左右加上引号。 例如，在 =VLOOKUP("袁",B2:E7,2,FALSE) 中输入姓氏“<b class="ocpLiteral">"袁"</b>”。</p>
                <p>有关详细信息，请参阅<a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#26356;&amp;#27491;-name-&amp;#38169;&amp;#35823;-b6d54e31-a743-4d7d-9b61-40002a7b4286" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">如何更正 #NAME! 错误</a>。</p>
              </td>
            </tr>
          </tbody>
        </table>
      </div>
    </div>
  </section>
  <section class="ocpSection">
    <h2 class="ocpExpandoHead">
      <a href="javascript:" ms.interactiontype="11" aria-expanded="false" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup" data-bi-slot="3" data-bi-mto="" ms.cmpgrp="content" ms.pgarea="Body">
        <div class="ocpExpandoHeadChevronContainer">
          <i class="ms-Icon--chevronThinDown ocpExpander"></i>
        </div>
        <div class="ocpExpandoHeadTitleContainer">最佳做法</div>
      </a>
    </h2>
    <div class="ocpebw" xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <div class="ocpExpandoBody">
        <table id="tblID0EAAEAAA" class="banded flipColors">
          <thead>
            <tr>
              <td>
                <p>
                  <b class="ocpLegacyBold">要执行的操作</b>
                </p>
              </td>
              <td>
                <p>
                  <b class="ocpLegacyBold">原因</b>
                </p>
              </td>
            </tr>
          </thead>
          <tbody>
            <tr>
              <td>
                <p>对 <i class="ocpItalic"><b class="ocpLegacyBold">range_lookup</b></i> 使用绝对引用</p>
              </td>
              <td>
                <p>通过使用绝对引用，可以向下填充公式，这样该公式始终在完全精确的查找区域内查找。</p>
                <p>了解如何使用<a href="https://support.office.com/zh-cn/article/&amp;#21019;&amp;#24314;&amp;#25110;&amp;#26356;&amp;#25913;&amp;#21333;&amp;#20803;&amp;#26684;&amp;#24341;&amp;#29992;-c7b8b95d-c594-4488-947e-c835903cebaa" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">绝对单元格引用</a>。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>请勿将数字或日期值存储为文本。</p>
              </td>
              <td>
                <p>在搜索数字或日期值时，请确保 <b class="ocpLegacyBold"><i class="ocpItalic">table_array</i></b> 第一列中的数据未存储为文本值。否则，VLOOKUP 可能返回不正确或意外的值。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>对第一列排序</p>
              </td>
              <td>
                <p>
                  <i class="ocpItalic">
                    <b class="ocpLegacyBold">range_lookup</b>
                  </i> 为 TRUE 时使用 VLOOKUP 之前对 <b class="ocpLegacyBold"><i class="ocpItalic">table_array</i></b> 的第一列排序。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>使用通配符</p>
              </td>
              <td>
                <p>如果 <b class="ocpLegacyBold"><i class="ocpItalic">range_lookup</i></b> 为 FALSE 且 <b class="ocpLegacyBold"><i class="ocpItalic">lookup_value</i></b> 为文本，则可以在 <b class="ocpLegacyBold"><i class="ocpItalic">lookup_value</i></b> 中使用通配符（问号 (?) 和星号 (*)）。问号匹配任意单个字符；星号匹配任意一串字符。如果要查找实际的问号或星号，请在该字符前键入波形符 (~)。</p>
                <p>例如，<span class="ocpCodeInline">=VLOOKUP("Fontan?",B2:E7,2,FALSE)</span> 将搜索最后一个字符不确定的所有“<b class="ocpLiteral">袁</b>”实例。</p>
              </td>
            </tr>
            <tr>
              <td>
                <p>请确保您的数据中不包含错误的字符。</p>
              </td>
              <td>
                <p>在第一列中搜索文本值时，请确保第一列中的数据没有前导空格、尾部空格、直引号（' 或 "）与弯引号（‘或“）不一致或非打印字符。否则，VLOOKUP 可能返回意外的值。</p>
                <p>要获得准确的结果，请尝试使用 <a href="https://support.office.com/zh-cn/article/clean-&amp;#20989;&amp;#25968;-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">CLEAN 函数</a>或 <a href="https://support.office.com/zh-cn/article/trim-&amp;#20989;&amp;#25968;-410388fa-c5df-49c6-b16c-9e5630b479f9" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">TRIM 函数</a>删除单元格中表格值后后面的后置空格。</p>
              </td>
            </tr>
          </tbody>
        </table>
      </div>
    </div>
  </section>
  <section class="ocpSection">
    <h2>你是否有特定函数问题？</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <a href="https://answers.microsoft.com/lang/msoffice/forum/msoffice_excel" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">在 Excel 社区论坛中发布问题</a>
    </p>
  </section>
  <section class="ocpSection">
    <h2>帮助我们改进 Excel</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">是否有关于如何改进下一版 Excel 的建议？如果有，请查看 <a href="https://excel.uservoice.com/" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">Excel User Voice</a> 上的主题。</p>
  </section>
  <section class="ocpSection">
    <h2>相关主题</h2>
    <p xmlns:antixss="urn:AntiXSSExtensions" xmlns:friendlytitlelookup="urn:FriendlyTitleLookup">
      <a href="https://support.office.com/zh-cn/article/&amp;#35838;&amp;#31243;&amp;#25688;&amp;#35201;&amp;#21345;&amp;#65306;-vlookup-&amp;#22797;&amp;#20064;-750fe2ed-a872-436f-92aa-36c17e53f2ee" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">课程摘要卡：VLOOKUP 复习</a>
      <br>
      <a href="https://support.office.com/zh-cn/article/&amp;#35838;&amp;#31243;&amp;#25688;&amp;#35201;&amp;#21345;&amp;#65306;-vlookup-&amp;#30097;&amp;#38590;&amp;#35299;&amp;#31572;&amp;#25552;&amp;#31034;-6fe7fe1b-709b-4958-adfb-9f2a409dcf38" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">课程摘要卡：VLOOKUP 疑难解答提示</a>
      <br>
      <a href="https://blogs.office.com/2012/03/23/you-asked-about-vlookup/" target="_blank" class="ocpExternalLink" ms.cmpgrp="content" ms.pgarea="Body">你需要了解的有关 VLOOKUP 的所有内容</a>
      <br>
      <a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#26356;&amp;#27491;-vlookup-&amp;#20989;&amp;#25968;&amp;#30340;-value-&amp;#38169;&amp;#35823;-1fabc766-32ae-4f7f-a2c4-d095153e6894" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">如何在 VLOOKUP 函数中更正 #VALUE! 错误</a>
      <br>
      <a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#26356;&amp;#27491;-vlookup-&amp;#20989;&amp;#25968;&amp;#20013;&amp;#30340;-n-a-&amp;#38169;&amp;#35823;-e037d763-ffc3-4fae-a909-89c482d389b2" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">如何在 VLOOKUP 函数中更正 #N/A 错误</a>
      <br>
      <a href="https://support.office.com/zh-cn/article/excel-&amp;#20013;&amp;#30340;&amp;#20844;&amp;#24335;&amp;#27010;&amp;#36848;-ecfdc708-9162-49e8-b993-c311f47ca173" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">Excel 中的公式概述</a>
      <br>
      <a href="https://support.office.com/zh-cn/article/&amp;#22914;&amp;#20309;&amp;#36991;&amp;#20813;&amp;#25439;&amp;#22351;&amp;#30340;&amp;#20844;&amp;#24335;-8309381d-33e8-42f6-b889-84ef6df1d586" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">如何避免损坏的公式</a>
      <br>
      <a href="https://support.office.com/zh-cn/article/&amp;#26816;&amp;#27979;&amp;#20844;&amp;#24335;&amp;#20013;&amp;#30340;&amp;#38169;&amp;#35823;-3a8acca5-1d61-4702-80e0-99a36a2822c1" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">检测公式中的错误</a>
      <br>
      <a href="https://support.office.com/zh-cn/article/excel-&amp;#20989;&amp;#25968;&amp;#65288;&amp;#25353;&amp;#23383;&amp;#27597;&amp;#39034;&amp;#24207;&amp;#65289;-b3944572-255d-4efb-bb96-c6d90033e188" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">Excel 函数（按字母顺序列出）</a>
      <br>
      <a href="https://support.office.com/zh-cn/article/excel-&amp;#20989;&amp;#25968;&amp;#65288;&amp;#25353;&amp;#31867;&amp;#21035;&amp;#21015;&amp;#20986;&amp;#65289;-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb" class="ocpArticleLink" ms.cmpgrp="content" ms.pgarea="Body">Excel 函数（按类别列出）</a>
    </p>
    
  </section>
</article>




















							
						</div>
							<div id="DisabledArticleTools"></div>
					</div>
					

					



	<div class="row supArticleContentFooterWrapper">
		<div id="articleContentFooterPadding" class=""></div>
		<div id="ocArticleContentFooter" class="col-5-5">
			<div class="ocArticleFooterSection">
				<div class="ocArticleFooterElementContainer" data-bi-area="article_footer">
											<div class="ocArticleFooterElement">
							<div class="ocArticleFooterElementTitle">
								扩展你的 Office 技能
							</div>
							<a class="ocArticleFooterElementCallToAction" href="https://support.office.com/zh-cn/office-training-center" data-bi-slot="2" ms.cmpgrp="content" ms.pgarea="Body">了解培训</a>
						</div>
											<div class="ocArticleFooterElement">
							<div class="ocArticleFooterElementTitle">
								抢先获得新功能
							</div>
							<a class="ocArticleFooterElementCallToAction" href="https://support.office.com/zh-cn/article/f4208185-b63a-4b68-9c7a-9a32d2411c16" data-bi-slot="3" ms.cmpgrp="content" ms.pgarea="Body">加入 Office 预览体验计划</a>
						</div>
					<div class="ocArticleFooterElement ocArticleFooterClearfix">
					</div>
				</div>
			</div>
		</div>
	</div>

				</div>
			</div>
		</section>

		<div id="ocFooterWrapper">

				<div id="supWrapperToPreventFeedbackFlickering">
					<section id="supFeedbackWrapper" class="supStickyFeedback">
						<div id="supColumnWrapper">
							
	

<div id="supFeedBackContainer">
	<section id="supFB" class="ocFB">
		<div id="supFBCont">
			<form name="smartFeedbackForm" class="smartFeedbackForm supStickyFeedbackMarginBottom" data-sentiment-analysis="true" data-support-available="true">
				<input name="__RequestVerificationToken" type="hidden" value="dcgLKaRSy0a-2iwnrtbgTJ-ay3ZOsQYi3IZa8acCP9y-l76-n4eh1iqmO7M3QTBT9i3Y-UZrOU0hStQidHTT4Ue-3pOV0-y22kkSJQANk4E1">
				<div class="ocSmartFeedbackBegin" role="region">
					<div id="beginFeedbackHeader" class="supStickyFeedbackHeader">
						<h2>此信息是否有帮助?</h2>
					</div>
					<div class="feedbackButtons">
						<button class="ocFeedbackButton supStickyFeedbackButton feedbackSelection" name="buttonYes" type="button" data-bi-mto="">是</button>
						<button class="ocFeedbackButton supStickyFeedbackButton feedbackSelection" name="buttonNo" type="button" data-bi-mto="">否</button>
					</div>
				</div>
				<div class="ocSmartFeedbackReply ocHidden">
					<div class="supStickyFeedbackHeader">
						<label for="feedbackText" class="ocFeedbackHeaderIfArticleHelpful ocHidden">很好! 还有其他反馈吗?</label>
						<label for="feedbackText" class="ocFeedbackHeaderIfArticleNotHelpful ocHidden">我们应该如何改进?</label>
					</div>
					<div id="ocProductArticleFeedback" class="ocFeedbackMoreInformation ocHidden">
						<label id="radioButtonProduct" class="ocProductArticleRadioContainer">产品
							<input type="radio" name="radio" value="product">
							<span class="ocProductArticleRadioCheckmark"></span>
						</label>
						<label id="radioButtonArticle" class="ocProductArticleRadioContainer">文章
							<input type="radio" name="radio" value="article">
							<span class="ocProductArticleRadioCheckmark"></span>
						</label>
					</div>
					<textarea class="ocSmartFeedbackTextArea" name="feedbackText" rows="6" cols="40" maxlength="250" placeholder="你告诉我们的内容越详细，我们可以提供的帮助就越多。" required=""></textarea>
					<div class="feedbackButtons">
						<button class="ocFeedbackButton supStickyFeedbackButton ocButtonSendComment" type="submit" data-bi-mto="">发送​​</button>
						<button class="ocFeedbackButton supStickyFeedbackButton ocButtonSendNoComment" type="button" data-bi-mto="">不，谢谢</button>
					</div>
				</div>
			</form>
			<div class="ocFeedbackFinalThankYouMessage ocHidden supStickyFeedbackHeader supStickyFeedbackMarginBottom">
				<h2>谢谢您的反馈!</h2>
			</div>
			<div class="ocFeedbackToChat ocHidden supStickyFeedbackHeader supStickyFeedbackMarginBottom">
				<h2>谢谢你的反馈! 可能需要转接到 Office 支持专员。</h2>
				<div class="feedbackButtons">
					<a class="smartFeedbackChatLink ocFeedbackButton" target="_top" ms.cmpgrp="content" ms.pgarea="Body">联系支持人员</a>
				</div>
			</div>
		</div>
	</section>
</div>

							<a href="javascript:" id="supDisableStickyFeedbackButton" class="" ms.interactiontype="11" aria-label="单击以禁用粘黏反馈横幅。" data-bi-bhvr="HIDE" ms.cmpgrp="content" ms.pgarea="Body">×</a>
						</div>
					</section>
				</div>

			
	

    <section id="footerArea" data-m="{&quot;cN&quot;:&quot;footerArea&quot;,&quot;cT&quot;:&quot;Area_coreuiArea&quot;,&quot;id&quot;:&quot;a2Body&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;Body&quot;}" ms.pgarea="Footer">
            <div id="footerRegion" data-region-key="footerregion" data-m="{&quot;cN&quot;:&quot;footerRegion&quot;,&quot;cT&quot;:&quot;Region_coreui-region&quot;,&quot;id&quot;:&quot;r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;a2&quot;}">

    <div id="footerUniversalFooter" data-m="{&quot;cN&quot;:&quot;footerUniversalFooter&quot;,&quot;cT&quot;:&quot;Module_coreui-universalfooter&quot;,&quot;id&quot;:&quot;m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;r1a2&quot;}" data-module-id="Category|footerRegion|footerRegion|footerUniversalFooter|coreui-universalfooter">
        

<footer id="uhf-footer" class="c-uhff context-uhf" data-uhf-mscc-rq="false" data-footer-footprint="/officesupport/officesupportfooter" data-m="{&quot;cN&quot;:&quot;Uhf footer_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;m1r1a2&quot;}">
            <nav class="c-uhff-nav" role="navigation" aria-label="页脚" data-m="{&quot;cN&quot;:&quot;Footer nav_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1m1r1a2&quot;}">
                
                    <div class="c-uhff-nav-row">
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn1_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c1c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">新增内容</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/p/surface-go/8v9dp4lnknsz" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_SurfaceGo_nav&quot;,&quot;id&quot;:&quot;n1c1c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">全新 Surface Go </a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/surface/devices/surface-book-2/overview" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_SurfaceBook2_nav&quot;,&quot;id&quot;:&quot;n2c1c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Surface Book 2</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/surface/devices/surface-pro/overview" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_NewSurfacePro_nav&quot;,&quot;id&quot;:&quot;n3c1c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Surface Pro</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.xbox.com/zh-cn/xbox-one-x" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_XboxOneX_nav&quot;,&quot;id&quot;:&quot;n4c1c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Xbox One X</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.xbox.com/zh-cn/xbox-one-s?xr=shellnav" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_XboxOneS_nav&quot;,&quot;id&quot;:&quot;n5c1c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Xbox One S</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/windows/windows-10-apps" data-m="{&quot;cN&quot;:&quot;Footer_WhatsNew_Windows_10_apps_nav&quot;,&quot;id&quot;:&quot;n6c1c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c1c1c1m1r1a2&quot;}" ms.pgarea="Body">Windows 10 应用程序</a>
                                            </li>

                                </ul>
                                
                            </div>
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn2_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c2c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">应用商店和支持
</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://account.microsoft.com/" data-m="{&quot;cN&quot;:&quot;Footer_StoreandSupport_AccountProfile_nav&quot;,&quot;id&quot;:&quot;n1c2c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c2c1c1m1r1a2&quot;}" ms.pgarea="Body">帐户个人资料</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/download" data-m="{&quot;cN&quot;:&quot;Footer_StoreandSupport_DownloadCenter_nav&quot;,&quot;id&quot;:&quot;n2c2c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c2c1c1m1r1a2&quot;}" ms.pgarea="Body">下载中心</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://account.microsoft.com/orders" data-m="{&quot;cN&quot;:&quot;Footer_StoreandSupport_OrderTracking_nav&quot;,&quot;id&quot;:&quot;n3c2c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c2c1c1m1r1a2&quot;}" ms.pgarea="Body">订单跟踪</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://support.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_StoreandSupport_Support_nav&quot;,&quot;id&quot;:&quot;n4c2c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c2c1c1m1r1a2&quot;}" ms.pgarea="Body">支持</a>
                                            </li>

                                </ul>
                                
                            </div>
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn3_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c3c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">教育</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/education" data-m="{&quot;cN&quot;:&quot;Footer_Education_MicrosoftInEducation_nav&quot;,&quot;id&quot;:&quot;n1c3c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c3c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft 教育领域</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/education/products/office/default.aspx" data-m="{&quot;cN&quot;:&quot;Footer_Education_OfficeForStudents_nav&quot;,&quot;id&quot;:&quot;n2c3c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c3c1c1m1r1a2&quot;}" ms.pgarea="Body">适合学生的 Office</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://products.office.com/zh-cn/academic/compare-office-365-education-plans" data-m="{&quot;cN&quot;:&quot;Footer_Education_Office365ForSchools_nav&quot;,&quot;id&quot;:&quot;n3c3c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c3c1c1m1r1a2&quot;}" ms.pgarea="Body">适用于学校的 Office 365</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://azure.microsoft.com/zh-cn/community/education/" data-m="{&quot;cN&quot;:&quot;Footer_MicrosoftAzureInEducation_nav&quot;,&quot;id&quot;:&quot;n4c3c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c3c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft Azure 教育领域</a>
                                            </li>

                                </ul>
                                
                            </div>
                    </div>
                    <div class="c-uhff-nav-row">
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn4_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c4c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">企业</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://partner.microsoft.com/zh-cn/" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_Enterprise_nav&quot;,&quot;id&quot;:&quot;n1c4c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">企业</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/sql-server/" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_DataPlatform_nav&quot;,&quot;id&quot;:&quot;n2c4c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">数据平台</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/solution-providers" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_FindASolutionsProvider_nav&quot;,&quot;id&quot;:&quot;n3c4c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">查找解决方案提供商</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://partner.microsoft.com/zh-cn/" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_MicrosoftPartnerResources_nav&quot;,&quot;id&quot;:&quot;n4c4c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft 合作伙伴资源</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/?LinkID=808093" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_MicrosoftAppSource_nav&quot;,&quot;id&quot;:&quot;n5c4c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft AppSource </a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://enterprise.microsoft.com/zh-cn/uncategorized/discrete-manufacturing/" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_ManufacturingAndResources_nav&quot;,&quot;id&quot;:&quot;n6c4c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">制造业与资源</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://enterprise.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Enterprise_FinanciaServices_nav&quot;,&quot;id&quot;:&quot;n7c4c1c1m1r1a2&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c4c1c1m1r1a2&quot;}" ms.pgarea="Body">金融服务</a>
                                            </li>

                                </ul>
                                
                            </div>
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn5_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c5c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">开发人员</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://visualstudio.microsoft.com/" data-m="{&quot;cN&quot;:&quot;Footer_Developer_MicrosoftVisualStudio_nav&quot;,&quot;id&quot;:&quot;n1c5c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft Visual Studio</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://developer.microsoft.com/zh-cn/windows" data-m="{&quot;cN&quot;:&quot;Footer_Developer_WindowsDevCenter_nav&quot;,&quot;id&quot;:&quot;n2c5c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">Windows 开发人员中心</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://msdn.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Developer_MicrosoftDeveloperNetwork_nav&quot;,&quot;id&quot;:&quot;n3c5c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">开发人员网络</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://technet.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Developer_TechNet_nav&quot;,&quot;id&quot;:&quot;n4c5c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">TechNet</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://developer.microsoft.com/zh-cn/store/register" data-m="{&quot;cN&quot;:&quot;Footer_Developer_MicrosoftDeveloperProgram_nav&quot;,&quot;id&quot;:&quot;n5c5c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft 开发人员计划</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://channel9.msdn.com/" data-m="{&quot;cN&quot;:&quot;Footer_Developer_Channel9_nav&quot;,&quot;id&quot;:&quot;n6c5c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">通道 9</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://developer.microsoft.com/zh-cn/office" data-m="{&quot;cN&quot;:&quot;Footer_Developer_OfficeDevCenter_nav&quot;,&quot;id&quot;:&quot;n7c5c1c1m1r1a2&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c5c1c1m1r1a2&quot;}" ms.pgarea="Body">Office 开发人员中心</a>
                                            </li>

                                </ul>
                                
                            </div>
                            <div class="c-uhff-nav-group" data-m="{&quot;cN&quot;:&quot;footerNavColumn6_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c6c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <h4 class="c-heading-4">公司</h4>
                                <ul class="c-list f-bare">
                                            <li>
                                                <a class="c-uhff-link" href="https://careers.microsoft.com/" data-m="{&quot;cN&quot;:&quot;Footer_Company_Careers_nav&quot;,&quot;id&quot;:&quot;n1c6c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">招贤纳士</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/about" data-m="{&quot;cN&quot;:&quot;Footer_Company_AboutMicrosoft_nav&quot;,&quot;id&quot;:&quot;n2c6c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">关于 Microsoft</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://news.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Company_CompanyNews_nav&quot;,&quot;id&quot;:&quot;n3c6c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">公司新闻</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://privacy.microsoft.com/zh-cn" data-m="{&quot;cN&quot;:&quot;Footer_Company_PrivacyAtMicrosoft_nav&quot;,&quot;id&quot;:&quot;n4c6c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">Microsoft 隐私</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/investor/default.aspx" data-m="{&quot;cN&quot;:&quot;Footer_Company_Investors_nav&quot;,&quot;id&quot;:&quot;n5c6c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">投资人</a>
                                            </li>
                                            <li>
                                                <a class="c-uhff-link" href="https://www.microsoft.com/zh-cn/security/default.aspx" data-m="{&quot;cN&quot;:&quot;Footer_Company_Security_nav&quot;,&quot;id&quot;:&quot;n6c6c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c6c1c1m1r1a2&quot;}" ms.pgarea="Body">安全性</a>
                                            </li>

                                </ul>
                                
                            </div>
                    </div>
            </nav>
    <div class="c-uhff-base">
                    <a id="locale-picker-link" aria-label="Content Language Selector. Currently set to 中文(中国)" class="c-uhff-link c-uhff-lang-selector c-glyph glyph-world" href="https://store.office.com/worldwide.aspx?rs=zh-cn&amp;cmapid=1" data-m="{&quot;cN&quot;:&quot;locale_picker(CN)_nav&quot;,&quot;id&quot;:&quot;n7c1c1m1r1a2&quot;,&quot;sN&quot;:7,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}" ms.pgarea="Body">中文(中国)</a>

        <ul role="list" aria-label="Microsoft 企业链接" class="c-list f-bare" data-m="{&quot;cN&quot;:&quot;Corp links_cont&quot;,&quot;cT&quot;:&quot;Container&quot;,&quot;id&quot;:&quot;c8c1c1m1r1a2&quot;,&quot;sN&quot;:8,&quot;aN&quot;:&quot;c1c1m1r1a2&quot;}">
                                <li>
                        <a class="c-uhff-link" href="https://support.office.com/home/contact?ContactUsExperienceEntryPointAssetId=0bbc8083-26fe-4963-8ab8-93a18ad188a1" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Contact Us_nav&quot;,&quot;id&quot;:&quot;n1c8c1c1m1r1a2&quot;,&quot;sN&quot;:1,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body" data-bi-bhvr="CALL">联系我们</a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/?LinkId=248681" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;PrivacyandCookies_nav&quot;,&quot;id&quot;:&quot;n2c8c1c1m1r1a2&quot;,&quot;sN&quot;:2,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">隐私与 Cookie</a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/p/?LinkId=530144" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Termsofuseandsale_nav&quot;,&quot;id&quot;:&quot;n3c8c1c1m1r1a2&quot;,&quot;sN&quot;:3,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">使用和销售条款 </a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="http://go.microsoft.com/?LinkId=9851308" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Trademarks_nav&quot;,&quot;id&quot;:&quot;n4c8c1c1m1r1a2&quot;,&quot;sN&quot;:4,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">商标 </a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/p/?LinkId=316963" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Accessibility_nav&quot;,&quot;id&quot;:&quot;n5c8c1c1m1r1a2&quot;,&quot;sN&quot;:5,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">Office 辅助功能</a>
                    </li>
                    <li>
                        <a class="c-uhff-link" href="https://go.microsoft.com/fwlink/p/?LinkId=530144" data-mscc-ic="false" data-m="{&quot;cN&quot;:&quot;Legal_nav&quot;,&quot;id&quot;:&quot;n6c8c1c1m1r1a2&quot;,&quot;sN&quot;:6,&quot;aN&quot;:&quot;c8c1c1m1r1a2&quot;}" ms.pgarea="Body">法律</a>
                    </li>

            <li>© Microsoft 2018</li>
            
        </ul>
    </div>
    
</footer>




    </div>
    </div>

    </section>



		</div>
	</div>
	<script src="./VLOOKUP 函数 - Office 支持_files/jquery-1.9.1.min.js.下载"></script>
<script>(window.jQuery)||document.write('<script src="/bundles/jquery"><\/script>');</script>

	
<script defer="" src="./VLOOKUP 函数 - Office 支持_files/stickyFeedback"></script>

<script defer="" src="./VLOOKUP 函数 - Office 支持_files/TopNav"></script>


	<script src="./VLOOKUP 函数 - Office 支持_files/support"></script>

	
	

<script src="./VLOOKUP 函数 - Office 支持_files/a3-892803"></script><script src="./VLOOKUP 函数 - Office 支持_files/meversion" defer=""></script>			<script type="text/javascript">
				$(function() {
					var msPageAreaValue = "Header";
					var msSignInInteractionValue = "11";
					var wcsSignInTextValue = "Sign in";

					function SetConsent() {
						var cookieConsentBannerNeeded = false;
						if (cookieConsentBannerNeeded) {
							var mscc = window.mscc;
							if (mscc && !mscc.hasConsent()) {
								mscc.setConsent();
							}
						}
					}

					var shellOptions = function() {
						return {
							currentMenuItemId: 'shell-main-tab',
							meControlOptions: {
								rpData: {
									msaInfo: {
										signInUrl: "https://login.live.com/login.srf?wa=wsignin1.0\u0026rpsnv=13\u0026ct=1533809412\u0026rver=7.0.6731.0\u0026wp=MBI_SSL\u0026wreply=https:%2F%2Fsupport.office.com%2Fauthredir%3Furl%3Dhttps%253a%252f%252fsupport.office.com%253a443%252fzh-cn%252farticle%252fvlookup-%252525E5%25252587%252525BD%252525E6%25252595%252525B0-0bbc8083-26fe-4963-8ab8-93a18ad188a1%253fui%253dzh-CN%2526rs%253dzh-CN%2526ad%253dCN%26hurl%3Di7nE7L4lxtjYqFY2MbtBfDIIJhKKmaciJzscHLyIkuo%253d.PMmwNAioIE24HdFY8ym9%252fBg96w7ZuAnOl%252f%252fnqDj58u4%253d%26ipt%3D0%26si%3D1%26wctx%3Ddd1b4e0d-b136-488e-9669-4c0f413e95bf\u0026lc=1033\u0026id=290950\u0026aadredir=1",
										signOutUrl: "https://login.live.com/logout.srf?ct=1533809413\u0026rver=7.0.6731.0\u0026lc=1033\u0026id=290950\u0026ru=https:%2F%2Fsupport.office.com%2Fauthredir%3Furl%3Dhttps%253a%252f%252fsupport.office.com%253a443%252fzh-cn%252farticle%252fvlookup-%252525E5%25252587%252525BD%252525E6%25252595%252525B0-0bbc8083-26fe-4963-8ab8-93a18ad188a1%253fui%253dzh-CN%2526rs%253dzh-CN%2526ad%253dCN%26hurl%3Di7nE7L4lxtjYqFY2MbtBfDIIJhKKmaciJzscHLyIkuo%253d.PMmwNAioIE24HdFY8ym9%252fBg96w7ZuAnOl%252f%252fnqDj58u4%253d%26ipt%3D0%26so%3D1"
									},
									aadInfo: {
										signInUrl: "https://login.microsoftonline.com/common/oauth2/authorize?response_mode=form_post\u0026response_type=id_token+code\u0026scope=openid\u0026nonce=0b183778-cb31-4c93-ac68-353bb8cbac09.636694057905535381\u0026state=https:%2f%2fsupport.office.com%2fzh-cn%2farticle%2fvlookup-%2525E5%252587%2525BD%2525E6%252595%2525B0-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3fui%3dzh-CN%26rs%3dzh-CN%26ad%3dCN\u0026client_id=4b233688-031c-404b-9a80-a4f3f2351f90\u0026redirect_uri=https:%2f%2fsupport.office.com%2fauth%2fsignin",
										signOutUrl: ""
									},
									preferredIdp: window.msCommonShell.SupportedAuthIdp.MSA
								},
								userData: {
								},
								events: {
									onEventLog: function (eventId) {
										if (eventId.toLowerCase() === "signin") {
											SetConsent();
											if (typeof window.awa === 'object') {
												var tags = {
													behavior: window.awa.behavior.SIGNIN,
													actionType: 'CL',
													content: {contentName: 'Sign in button', areaName:'Me control header'}
												}
												awa.ct.captureContentPageAction(tags);
											}
										} else if (eventId.toLowerCase() === "dropdownopen") {
											SetConsent();
										}
									}
								}
							},
							events: {
								onSearch: function (searchForm) {
									occe.AutoSuggestSearchEvent(searchForm, msPageAreaValue, 'false');
								}
							},
							as: {
								callback: function () {}
							}
						};
					};

					// If msCommonShell already exists, load it
					if (window.msCommonShell) {
						window.msCommonShell.load(shellOptions());
					}

					// If msCommonShell doesn't yet exist...
					else {

						// Load the me control once msCommonShell is ready
						window.onShellReadyToLoad = function () {
							window.onShellReadyToLoad = null;
							window.msCommonShell.load(shellOptions());
						};
					}

					// Append returnURL query param to change language control on footer
					// Add returnURL to click instead of updating the URL to hide the encoded return url on hover over change language control
					(function () {
						var returnUrlForChangeLanguageHref = window.location.href;
						var $idOfChangeLanguageonFooter = $('#locale-picker-link');
						var hrefOfChangeLanguageOnFooter = $idOfChangeLanguageonFooter.attr('href');

						if (hrefOfChangeLanguageOnFooter) {
							$idOfChangeLanguageonFooter.on('click keypress', function (e) {
								e.preventDefault();
								if (occe.eventHelpers.eventIsClick(e) || occe.eventHelpers.eventIsEnterKeypress(e)) {
									var newChangeLanguageOnFooterUrl = occe.updateQueryStringParameter('returnURL', encodeURIComponent(returnUrlForChangeLanguageHref), hrefOfChangeLanguageOnFooter);
									window.location.href = newChangeLanguageOnFooterUrl;
								}
							});
						}
					})();
				});
			</script>
				


	<script src="./VLOOKUP 函数 - Office 支持_files/a3-892803"></script><script src="./VLOOKUP 函数 - Office 支持_files/meversion" defer=""></script>			<script type="text/javascript">
				$(function() {
				})
			</script>


	<script defer="" src="./VLOOKUP 函数 - Office 支持_files/article"></script>


	

	


	<script id="supResourcesScript" type="text/javascript">
			$(function() {
				if (occe && occe.Resources) {
					occe.Resources.addLocalizedStrings({"L_ArticleTools_LiveIcon_Description":"Live button","L_ArticleTools_PreviewIcon_Description":"Preview button","L_TabControl_AriaLabel_FirstTab":"选项卡列表。有 {0} 个选项卡可用。","L_TabControl_AriaLabel_TabCollapsed":"{0}。已折叠。","L_TabControl_AriaLabel_TabExpanded":"{0}。已展开。","L_TabControl_AriaLabel_TabsOverflowDropdownIcon_Collapsed":"更多选项卡下拉列表。已折叠。按 Enter 键可展开下拉列表。","L_TabControl_AriaLabel_TabsOverflowDropdownIcon_Expanded":"更多选项卡下拉列表。已展开。按 Tab 键以通过可用选项卡进行导航。","L_CardControl_AriaLabel_DescriptiveCard_FooterText":"培训课程库。{0} 个培训课程(共 {1} 个)。{2}。每个课程有 {3} 个视频。按 Enter 键可启动课程，按 Tab 键可收听下一堂课。","L_CardControl_AriaLabel_DescriptiveCard_MinutesSeconds":"培训课程库。第 {0} 个培训课程，共 {1} 个。{2}。本课程共 {3} 分 {4} 秒。按 Enter 键启动课程，按 Tab 键收听下一课程。","L_CardControl_AriaLabel_DescriptiveCard_MinuteSeconds":"培训课程库。第 {0} 个培训课程，共 {1} 个。{2}。本课程共 {3} 分 {4} 秒。按 Enter 键启动课程，按 Tab 键收听下一课程。","L_CardControl_AriaLabel_DescriptiveCard_MinutesSecond":"培训课程库。第 {0} 个培训课程，共 {1} 个。{2}。本课程共 {3} 分 {4} 秒。按 Enter 键启动课程，按 Tab 键收听下一课程。","L_CardControl_AriaLabel_DescriptiveCard_MinuteSecond":"培训课程库。第 {0} 个培训课程，共 {1} 个。{2}。本课程共 {3} 分 {4} 秒。按 Enter 键启动课程，按 Tab 键收听下一课程。","L_CardControl_AriaLabel_Card_FooterText":"{0} 个课程(共 {1} 个)。{2}。存在 {3} 个视频。按 Enter 键可启动视频。","L_CardControl_AriaLabel_Card_MinutesSeconds":"第 {0} 个课程，共 {1} 个。{2}。课程长度: {3} 分 {4} 秒。","L_CardControl_AriaLabel_Card_MinuteSeconds":"第 {0} 个课程，共 {1} 个。{2}。课程长度: {3} 分 {4} 秒。","L_CardControl_AriaLabel_Card_MinutesSecond":"第 {0} 个课程，共 {1} 个。{2}。课程长度: {3} 分 {4} 秒。","L_CardControl_AriaLabel_Card_MinuteSecond":"第 {0} 个课程，共 {1} 个。{2}。课程长度: {3} 分 {4} 秒。","L_CardControl_AriaLabel_PreviousButton":"按 Enter 键收听之前的课程。","L_CardControl_AriaLabel_NextButton":"按 Enter 键收听更多可听课程。","L_EditInC3":"edit","L_IA_Feedback_Recorded":"感谢你提供反馈。","L_TrainingTips_AriaLabel_NextArrow":"按 Enter 键收听下一提示。","L_TrainingTips_AriaLabel_PrevArrow":"按 Enter 键收听上一提示。","L_TrainingTips_AriaLabel_Close":"对话框关闭按钮。按 Enter 键可折叠提示对话框。"});
					occe.Resources.addSettings({"OdcSup_C3EntryPoint_Enabled":"True","OdcSup_C3EntryPoint_UrlFormat":"https://c3web.trafficmanager.net/topic/{0}","OdcSup_ContextTabActivation_SignIn":"True"});
				}
			});
	</script>



	


<script src="./VLOOKUP 函数 - Office 支持_files/angular"></script>
<script defer="" src="./VLOOKUP 函数 - Office 支持_files/autoSuggest"></script>

		<script type="text/javascript" src="./VLOOKUP 函数 - Office 支持_files/vxp.js.下载" defer=""></script>

		<script type="text/javascript" src="./VLOOKUP 函数 - Office 支持_files/broker.js.下载" defer=""></script>


<script type="text/javascript">


	var config = {
		syncMuid: (typeof OOGlobal === "undefined" || typeof OOGlobal.IsCookieConsentRequired  === "undefined")
			? true : (!OOGlobal.IsCookieConsentRequired || (typeof(mscc) != "undefined" && mscc.hasConsent())),
		autoCapture: {
			scroll: false,
			resize: true
		},
		coreData: {
			appId: 'support.office.com',
			pageTags: {}
		},
		isLoggedIn: false,
		shareAuthStatus: true,
		authMethod: Number(0),
		callback: {
			pageViewPageTags: returnPageInfo,
			pageActionPageTags: returnPageInfo,
			contentUpdatePageTags: returnPageInfo
		}
	};

	if (occe.experimentRunningOnPage()) {
		occe.updateAwaExperimentTags(config);
	};

	if (occe.elementIsOnPage('.ocpEditArticleLink')) {
		config.coreData.pageTags['ver'] = 'editShown';
	}

	var $conditionalContentLocalizationElements = $("*[conditionalContentLocalization]");
	if ($conditionalContentLocalizationElements.length) {
		config.coreData.pageTags = config.coreData.pageTags || {};
		config.coreData.pageTags['conditionalContentLocalization'] = $conditionalContentLocalizationElements.first().attr('conditionalContentLocalization');

		$conditionalContentLocalizationElements.slice(1).each(function() {
			config.coreData.pageTags['conditionalContentLocalization'] += ',' + $(this).attr('conditionalContentLocalization');
		});
	}

	awa.init(config);

	function returnPageInfo() {
		return config.coreData.pageTags;
	};
</script>
		<script type="text/javascript">
			$(document).ready(function() {
				var divDisabledArticleTools = $(document).find('#DisabledArticleTools');

				occe.articleTools = (function createArticleToolsModule() {
					function displayTools() {
						$.ajax(
							{
								url: '/zh-cn/article/articletools/0bbc8083-26fe-4963-8ab8-93a18ad188a1?version=59\u0026storageType=Live\u0026isHoverEnabled=True\u0026assetOwnerAlias=chrsm%40microsoft.com%3Bmaxcontentfeedback%40microsoft.com\u0026mailToUri=mailto%3Achrsm%40microsoft.com%3Bmaxcontentfeedback%40microsoft.com%3Fsubject%3DFeedback%2520on%2520%2522VLOOKUP%2520%25e5%2587%25bd%25e6%2595%25b0%2522%2520%255b0bbc8083-26fe-4963-8ab8-93a18ad188a1%255d',
								context: document.body
							}
						).done(function(res) {
							$(divDisabledArticleTools).replaceWith(res);

							var articleToolsDisplayMode = $(document).find('#supArticleTool');
							if (articleToolsDisplayMode) {
								var $articleContentRoot = $(document).find('#supArticleContent');
								if ($articleContentRoot.hasClass("col-5-5")) {
									$articleContentRoot.removeClass("col-5-5").addClass("col-4-5");
								}
								else if ($articleContentRoot.hasClass("col-3-4")) {
									$articleContentRoot.removeClass("col-3-4").addClass("col-3-5");
								}

								var $lefNaveViewRoot = $(document).find('#supLeftNav');
								if ($lefNaveViewRoot.hasClass("col-1-4")) {
									$lefNaveViewRoot.removeClass("col-1-4").addClass("col-1-5");
								}

								var $multiMediaLeftNavRoot = $(document).find('#supMultimediaLeftNav');
								if ($multiMediaLeftNavRoot.hasClass("col-1-4")) {
									$multiMediaLeftNavRoot.removeClass("col-1-4").addClass("col-1-5");
								}

								var $articleContentFooterPadding = $(document).find('#articleContentFooterPadding');
								if ($articleContentFooterPadding.hasClass("col-1-4")) {
									$articleContentFooterPadding.removeClass("col-1-4").addClass("col-1-5");
								}

								var $articleContentFooter = $(document).find('#ocArticleContentFooter');
								if ($articleContentFooter.hasClass("col-5-5")) {
									$articleContentFooter.removeClass("col-5-5").addClass("col-4-5");
								}
								else if ($articleContentFooter.hasClass("col-3-4")) {
									$articleContentFooter.removeClass("col-3-4").addClass("col-3-5");
								}
							}
						});
					}

					return{
						displayTools: displayTools
					}
				})();
			});
		</script>
			<script type="text/javascript">
			$(function(){
				occe.articleToolsLogger.sendEventLogging(false);
				occe.c3EditLinkLogger.sendEventLogging(false);
			});
		</script>


<iframe src="./VLOOKUP 函数 - Office 支持_files/a3698060313.html" hidden="" aria-hidden="true" tabindex="-1" height="0" width="0" style="display: none;"></iframe><script src="./VLOOKUP 函数 - Office 支持_files/broker-config.js.下载"></script><div id="meControlDropdown" class="msame_Drop_root" style="display: none;" aria-expanded="false"><div tabindex="0" class="msame_focus_trap" aria-hidden="true"></div><div class="msame_Drop_topb"></div><div class="msame_Drop_content" role="dialog" tabindex="-1" aria-label="你的帐户"><div class="msame_Drop_active"></div><div class="msame_Drop_rewards" style="display: none;"></div><div class="msame_Drop_account"></div><div class="msame_Drop_links" style="display: none;"><div class="msame_Drop_links_list"></div></div><div class="msame_Drop_signIn"><div id="msame_si0" class="msame_Drop_SI" data-mc-m="{&quot;id&quot;:&quot;signIn&quot;,&quot;aN&quot;:&quot;Me Control Dropdown&quot;,&quot;cT&quot;:&quot;Link&quot;}"><a href="https://support.office.com/zh-cn/article/vlookup-%E5%87%BD%E6%95%B0-0bbc8083-26fe-4963-8ab8-93a18ad188a1#" target="_self" class="msame_TxtTrunc">使用另一个帐户登录</a></div></div><div class="msame_Drop_signOut"></div><div class="msame_Drop_accts" style="display: none;"><div class="msame_Drop_sep"></div><div class="msame_Drop_accts_list"></div></div></div><div tabindex="0" class="msame_focus_trap" aria-hidden="true"></div></div></body></html>